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: 222
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