Wednesday, 11 September 2019

Connecting Windows Internal Database using SQL Management Studio


Connecting Windows Internal Database using SQL Management Studio

s

For server name enter \\.\pipe\MICROSOFT##WID\tsql\query in case if we are connecting to Windows Server 2012 internal database. (Working for 2019 also)
o If we are connecting to windows 2003 and 2008 windows internal DB then we ne use  \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

s1

No comments:

Post a Comment

Windows 10's God Mode

God Mode  in Windows 10 gives you quick access to a ton of handy settings in one place.  Right-click on the desktop and go to New > ...