开发者

I cant reach my new SQL instance

开发者 https://www.devze.com 2023-01-19 15:21 出处:网络
I was using a older version of SQL on my server, and it worked fine when only typing the servername,, I could directly connect to the server,

I was using a older version of SQL on my server, and it worked fine when only typing the servername,, I could directly connect to the server,

I recently installed a new instance of SQL, and Iam trying to connect to the new instance but it dowsne't work.

SERVERNAME/New_instance

CAn someone开发者_JAVA百科 help me out? How can I reach the new SQL server?


try servername\new_instance (notice the direction of the slash)


are you trying to connect to the instance from your desktop, or from the local machine the instance is installed on? if you're trying to connect from your desktop (aka remotely), you might not have remote connections enabled. try turning this on.


You may need to allow both SQL Server & Windows Authentication

Do this by

  1. In SQL Server Management Studio
  2. Right click on Instance name
  3. Select 'Security'
  4. Select 'SQL Server and Windows Authentication mode'


You might also need to turn on the SQL Browser Agent or whatever it's called.

0

精彩评论

暂无评论...
验证码 换一张
取 消