如何查看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!