Why does this login fail for user 'Servername\Guest'?

Posted by Metassebia on Server Fault See other posts from Server Fault or by Metassebia
Published on 2011-03-10T13:54:59Z Indexed on 2011/03/10 16:12 UTC
Read the original article Hit count: 200

Filed under:
|
|
|

I install SQL Server 2005 EXPRESS edition on one computer, Computer Name = 'MyServe' and Database name='MyDB',take it as database server. it is configured as both Database and Windows Authentication Mode. with username=sa and password=adminaa. I have application in C#.Net my connection string is ConnectionString = "Data Source=MyServe\SQLEXPRESS;Initial Catalog=MyDB;Integrated Security=True;User ID=sa;Password=adminaa";

when I run the application on the computer called MyServe, the database server, it works well, while when I install the application on different computer, when it tries to connect the database it gives an error called "login failed for user 'MyServe\Guest" what is wrong with configuration in the database server or other mistakes. please help me. thankyou in advance.

Metasebia

© Server Fault or respective owner

Related posts about sql-server-2005

Related posts about login