Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
peperb
Starting Member
4 Posts |
 Posted - 2004-10-16 : 05:24:54
|
| Hello to everyone. I 'm new to the SQL SERVER section, and i found a litle problem.I have two computers (connected through ethernet) and i installed SS2000(Sql Server 2000) to both of them.I created an instance to the server and when i tried to see the instance from the client, the steps are below: registered new instance trying to connect ,shows the warning : ---"A connection could not be established to ServerName\InstanceName.Reason: Login failed for user 'ServerName\Guest'..Please verify SQL SERVER is running and check your SQL SERVER properties(by right -clicking on the ServerName\InstanceName node) and try again."--- Thank's for your time....in advance.Any ideas appriciated! |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-16 : 06:13:56
|
| Maybe Guest is not granted any permissions on the remote machine. Can you try to connect as a user with more permissions, or as SA?Are the SQL Server installations set up to allow "Mixed security" logins, or just Windows logins? Sounds like it is set for Windows logins, and the SQL Server is not recngnising the [windows] login from the remote machine.Kristen |
 |
|
|
peperb
Starting Member
4 Posts |
Posted - 2004-10-16 : 06:27:57
|
| yes, youu re right it is set up only for windows logins.what can i do? do i have to install again the instance? |
|
|
|
peperb
Starting Member
4 Posts |
Posted - 2004-10-16 : 06:51:15
|
Well, i created a new instance from server with mixed security and worked!!! I can see it from client and register with 'sa' Thank you, Kristen, very much for your advice - idea. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-16 : 10:14:38
|
| You can change to mixed mode - open Enterprise Manager on the server, check Properties on the Server in question, and then you can change the logon security style.I presume that E.M. will always [assuming the rights of the original user that E.M. runs under are not changed!] manage to login, on the machine it was originally installed on ...Kristen |
|
|
|
peperb
Starting Member
4 Posts |
Posted - 2004-10-17 : 02:56:28
|
| Right, it worked.Thank you. |
|
|
|
|
|
|
|
|
Connection problem!!!