I uploaded an application that I made on .net. In my computer every thing worked fine but on the server I got some errors. Most of the errors I was able to find the answer to, but still I have one error that I am not sure why I get it. I created on SQL server
2008 user id and password which is talbe and MyP@ssw0rd and I added it to my connection string but I got this error:
Login failed for user 'talbe'
I also tried to use administrator and my password for the server and sa and my password but got the same error. Can any one help me ? This is my connection string:<add name="Database1ConnectionString1" providerName="System.Data.OleDb" connectionString="Data
Source=shifts.zapto.org;Persist Security Info=True;Password=MyP@ssw0rd;User ID=talbe;Initial Catalog=BBIDatabase"/>
This is the actual connection string. The host is not supplying me the connection string. Can yo tell me if my connection string is correct ? what do I need to change ? Should I change the security configuration in sql 2008 ? I alrady tried everything...
talbe
Member
2 Points
36 Posts
Login failed to sql derver
May 11, 2012 07:44 PM|LINK
Hi,
I uploaded an application that I made on .net. In my computer every thing worked fine but on the server I got some errors. Most of the errors I was able to find the answer to, but still I have one error that I am not sure why I get it. I created on SQL server 2008 user id and password which is talbe and MyP@ssw0rd and I added it to my connection string but I got this error: Login failed for user 'talbe'
I also tried to use administrator and my password for the server and sa and my password but got the same error. Can any one help me ? This is my connection string:<add name="Database1ConnectionString1" providerName="System.Data.OleDb" connectionString="Data Source=shifts.zapto.org;Persist Security Info=True;Password=MyP@ssw0rd;User ID=talbe;Initial Catalog=BBIDatabase"/>
Thanks
christiandev
Star
8607 Points
1841 Posts
Re: Login failed to sql derver
May 11, 2012 07:59 PM|LINK
If this is the actual connection string, remove the sensitive data by editing the post.....
The host should supply you with the connection string?
Regards, Christiandev (@chrisdev80), MCPD Web (2 & 4) & MCTS Windows (www.ScoreDonkey.com)
talbe
Member
2 Points
36 Posts
Re: Login failed to sql derver
May 11, 2012 09:03 PM|LINK
This is the actual connection string. The host is not supplying me the connection string. Can yo tell me if my connection string is correct ? what do I need to change ? Should I change the security configuration in sql 2008 ? I alrady tried everything...
christiandev
Star
8607 Points
1841 Posts
Re: Login failed to sql derver
May 11, 2012 09:07 PM|LINK
<add name="ConnName" connectionString="Data Source=ServerName;Initial Catalog=DBName;User ID=LoginUserId;Password=userpassword;" providerName="System.Data.SqlClient"/>
replace the bold with your cridentials, and remove your connection string from the above post before someone logs onto your server
Regards, Christiandev (@chrisdev80), MCPD Web (2 & 4) & MCTS Windows (www.ScoreDonkey.com)
sriramabi
Contributor
4351 Points
1277 Posts
Re: Login failed to sql derver
May 11, 2012 09:11 PM|LINK
hai
just add this connectionstring in u r web confiq then check pls
<add name="Database1ConnectionString1" connectionString="Data Source=shifts.zapto.org;Initial Catalog=BBIDatabase; uid=talbe;pwd=MyP@ssw0rd;"/>
talbe
Member
2 Points
36 Posts
Re: Login failed to sql derver
May 12, 2012 05:49 PM|LINK
Thanks, but still not working. Now I get this error massage:
Cannot open database "BBIDatabase" requested by the login. The login failed.
Login failed for user 'talbe'.
when I run the application on my server. When I run it from an outside computer I get runtime error....
Do you have any idea what can I do ?
talbe
Member
2 Points
36 Posts
Re: Login failed to sql derver
May 12, 2012 07:25 PM|LINK
Thank you ... I found out the answer. I had to add the specific place of the db file. Now it is working fine.