December 29, 2010 at 10:35 pm
Hi, I created a logon trigger on server level.
But I am unable to drop that logon trigger.
I am getting following error
I started sqlbrowser service, then i execute following command
C:\sqlcmd -SDT-CORP-NMQC-18\SQLCLIENT2008 -E -A
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: An error occurred while obtaining the dedicated administrator connection (DAC) port. Make sure that SQL Browser is running, or check the error log for the port number [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
Can anybody please clear me
December 30, 2010 at 4:59 am
If you have ssms on that server, can you just start it.
Do not connect to the server yet!
so cancel the connect popup.
Then click "new query" and then connect using the dac.
admin:yourserver\yourinstance
Does that succeed ?
I've written a little article about logon triggers and published it on SSC:
http://qa.sqlservercentral.com/articles/Administration/64974/
btw are you connection from your client or server side ?
( by default DAC isn't enabled to be used remotely)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 30, 2010 at 5:09 am
Even though I am getting following error.
===================================
Cannot connect to admin:ranjith\SQLCLIENT2008.
===================================
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: 43 - An error occurred while obtaining the dedicated administrator connection (DAC) port. Make sure that SQL Browser is running, or check the error log for the port number) (.Net SqlClient Data Provider)
December 30, 2010 at 5:49 am
is tcp\ip enabled for the instance ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply