Re: SQL Server 2005 and security patch issues?
- From: Ekrem Önsoy <ekrem@xxxxxxxxxxxx>
- Date: Fri, 26 Sep 2008 23:33:47 +0300
I guess the problem occurs while you are trying to log in to your SQL Server instance, if so, do you get any error message?
Also, by default, a Login is created in your SQL Server instance for Local Administrators Windows Group. So, if you explicitly did not drop it, it still must be exist in your problematic SQL Server instance. Have you tried to connect to your SQL Server instance using a member of Local Admin group and Windows Authentication?
Also, have you checked the SQL Error Log? You may find some clues in this log file. ("<x>:\program files\Microsoft SQL Server\MSSQL.<x>\MSSQL\LOG")
--
Ekrem Önsoy
"David" <David@xxxxxxxxxxxxx> wrote in message news:F463F8D8-9695-4587-B83C-442B81F3ECB4@xxxxxxxxxxxxxxxx
Yesterday, I got a call from a customer. It seems my application had stopped
working. This application monitors equipment and stores data in an instance
of SQL Server 2005. For single devices, we use SQL Server 2005 Express
Edition.
After discussing things, we decided that the problem was that his instance
of SQL Server 2005 wasn't talking to him anymore. I booted up my machine
that has the same application. Mine had been running glitch free for about
18 months. Suddenly, my copy didn't work, either. I tried every way to
connect that I knew. The system uses SQL authentication when running, and
neither the named user nor the sa, which are the only two created users,
could get to that server.
It seemed awfully odd that my customer and I would have the same problem on
the same day. I realized that IT had pushed a security patch down to the
system the day before.
Are there any issues known for recent security patches and SQL Server 2005?
For what it's worth, I recreated a fresh instance and a fresh copy of the
database, and my application worked fine with that new instance. However, I
still can't connect to the old instance. Neither can my customer, and he was
sort of hoping to get at the data the application had collected.
.
- References:
- SQL Server 2005 and security patch issues?
- From: David
- SQL Server 2005 and security patch issues?
- Prev by Date: Re: SA user has lost is SYSADMIN role
- Next by Date: Re: SQL Server 2005 and security patch issues?
- Previous by thread: SQL Server 2005 and security patch issues?
- Next by thread: Re: SQL Server 2005 and security patch issues?
- Index(es):
Relevant Pages
|
