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 |
|
Largo
Starting Member
22 Posts |
 Posted - 2009-09-24 : 00:13:17
|
| My colleague has SQL Server 2008 Express on his machine. He needs to connect to my SQL Server. I found out that it's not necessary to create Windows login. I can just create SQL Server login. How to do it?-----There is no knowledge that is not power. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Largo
Starting Member
22 Posts |
Posted - 2009-09-24 : 01:31:21
|
| The thing is neither his nor my machine is in domain. I created login, but he still can't login. :(-----There is no knowledge that is not power. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Largo
Starting Member
22 Posts |
Posted - 2009-10-01 : 05:53:32
|
| Here's error that SQL Server shows:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol).My and colleague's server both allow remote connections. What is wrong?-----There is no knowledge that is not power. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-01 : 06:03:22
|
| http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Creating new login [SQL Server 2008 Express]