July 21, 2008 at 2:15 pm
Well I really messed up my test server, I was trying to work on a project from here to Learn more about SSIS: http://www.sqlservercentral.com/articles/Integration+Services/61621/
Well I thought it would be a good idea to set my concurrent users to 1. Now I cant log into the test server and keep getting kicked out after a successful log in. There are two instances of SQL Server running on this test server, not sure that it matters.
I need some way of changing this back to its default setting.
Please help...
July 21, 2008 at 2:29 pm
Have you tried using the Dedicated Admin Connection? (Look it up in Books Online if you're not sure how to do that.) That should allow you to fix this.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 21, 2008 at 2:45 pm
Yes that is what I am trying right now, but it wasnt enabled when I made the change and I cant figure out how to submit the T-SQL command to enable DAC for remote connections.
Right now I can attach to the engine(through mang. studio) by stopping the Agent service but have very limited things I can access this way.
sp_configure 'remote admin connections', 1;
GO
RECONFIGURE;
GO
That is what I am trying to submit, but when I click on 'New Query' it kicks me out.
July 21, 2008 at 2:47 pm
The only other thing I can think of is to use a command-line connection, instead of Management Studio. I'm not sure how to do that (I've read about it, but never used it). Try that, maybe?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 21, 2008 at 3:52 pm
I eventually fixed it - I 'faked' out the concurrent users by keeping the SQL Agent service off, and changing the Log On information for the server service.
By switching back and forth between my service account and my sysadmin account I was able to get into the Properties tab of the Mang. Studio, change the setting and get it to execute the change.
Reboot the server after you have executed your change then everything should come back fine. At least it did for me.
Solution: Dont ever set Concurrent users to 1 😛
July 22, 2008 at 11:38 am
Glad you worked it out. Good job.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply