如何查看sqlserver的端口号?就是localhost:????请大虾帮忙~~!

如何查看sqlserver的端口号?就是localhost:????请大虾帮忙~~!
sqlserver连接tcp/ip是怎么回事?
我查看数据库的属性,他却说我没权限,可是我是以administrator登陆的呀!!
我的sqlserver在本机上!!
---------------------------------------------------------------

在SQL SERVER NETWORK UTILITY中查看。
---------------------------------------------------------------

q2:我查看数据库的属性,他却说我没权限,可是我是以administrator登陆的呀??
try:
exec master.dbo.xp_regwrite 'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',
'Loginmode','REG_DWORD',2

reboot server,and then login with administrator again!

Published At
Categories with 数据库类
comments powered by Disqus