In SQL Server 2005, I renamed a database but it did not rename it in the
login default database. Since this is the default database for the sa
signon, I can't sign into the SQL Server. I am in a catch-22. I have only
one other login to the SQL Server and it also defaults to the same database
that apparently didn't get renamed :(.
Please help me get access to my SQL Server again,
TerryThis is a multi-part message in MIME format.
--030709040002030508020607
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
I answered this in microsoft.public.sqlserver.security.
--
*mike hodgson*
http://sqlnerd.blogspot.com
Terry wrote:
>In SQL Server 2005, I renamed a database but it did not rename it in the
>login default database. Since this is the default database for the sa
>signon, I can't sign into the SQL Server. I am in a catch-22. I have only
>one other login to the SQL Server and it also defaults to the same database
>that apparently didn't get renamed :(.
>Please help me get access to my SQL Server again,
>Terry
>
>
--030709040002030508020607
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>I answered this in microsoft.public.sqlserver.security.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Terry wrote:
<blockquote cite="mid600A72B6-BFBE-4475-BB1A-F6EACEED0CBC@.microsoft.com"
type="cite">
<pre wrap="">In SQL Server 2005, I renamed a database but it did not rename it in the
login default database. Since this is the default database for the sa
signon, I can't sign into the SQL Server. I am in a catch-22. I have only
one other login to the SQL Server and it also defaults to the same database
that apparently didn't get renamed :(.
Please help me get access to my SQL Server again,
Terry
</pre>
</blockquote>
</body>
</html>
--030709040002030508020607--
Showing posts with label renamed. Show all posts
Showing posts with label renamed. Show all posts
Tuesday, March 27, 2012
Can't get into sa account
In SQL Server 2005, I renamed a database but it did not rename it in the
login default database. Since this is the default database for the sa
signon, I can't sign into the SQL Server. I am in a catch-22. I have only
one other login to the SQL Server and it also defaults to the same database
that apparently didn't get renamed
.
Please help me get access to my SQL Server again,
Terry
I answered this in microsoft.public.sqlserver.security.
*mike hodgson*
http://sqlnerd.blogspot.com
Terry wrote:
>In SQL Server 2005, I renamed a database but it did not rename it in the
>login default database. Since this is the default database for the sa
>signon, I can't sign into the SQL Server. I am in a catch-22. I have only
>one other login to the SQL Server and it also defaults to the same database
>that apparently didn't get renamed.
>Please help me get access to my SQL Server again,
>Terry
>
>
sql
login default database. Since this is the default database for the sa
signon, I can't sign into the SQL Server. I am in a catch-22. I have only
one other login to the SQL Server and it also defaults to the same database
that apparently didn't get renamed
.Please help me get access to my SQL Server again,
Terry
I answered this in microsoft.public.sqlserver.security.
*mike hodgson*
http://sqlnerd.blogspot.com
Terry wrote:
>In SQL Server 2005, I renamed a database but it did not rename it in the
>login default database. Since this is the default database for the sa
>signon, I can't sign into the SQL Server. I am in a catch-22. I have only
>one other login to the SQL Server and it also defaults to the same database
>that apparently didn't get renamed
.>Please help me get access to my SQL Server again,
>Terry
>
>
sql
Can't get into sa account
In SQL Server 2005, I renamed a database but it did not rename it in the
login default database. Since this is the default database for the sa
signon, I can't sign into the SQL Server. I am in a catch-22. I have only
one other login to the SQL Server and it also defaults to the same database
that apparently didn't get renamed.
Please help me get access to my SQL Server again,
TerryI answered this in microsoft.public.sqlserver.security.
*mike hodgson*
http://sqlnerd.blogspot.com
Terry wrote:
>In SQL Server 2005, I renamed a database but it did not rename it in the
>login default database. Since this is the default database for the sa
>signon, I can't sign into the SQL Server. I am in a catch-22. I have only
>one other login to the SQL Server and it also defaults to the same database
>that apparently didn't get renamed.
>Please help me get access to my SQL Server again,
>Terry
>
>
login default database. Since this is the default database for the sa
signon, I can't sign into the SQL Server. I am in a catch-22. I have only
one other login to the SQL Server and it also defaults to the same database
that apparently didn't get renamed
.Please help me get access to my SQL Server again,
TerryI answered this in microsoft.public.sqlserver.security.
*mike hodgson*
http://sqlnerd.blogspot.com
Terry wrote:
>In SQL Server 2005, I renamed a database but it did not rename it in the
>login default database. Since this is the default database for the sa
>signon, I can't sign into the SQL Server. I am in a catch-22. I have only
>one other login to the SQL Server and it also defaults to the same database
>that apparently didn't get renamed
.>Please help me get access to my SQL Server again,
>Terry
>
>
Subscribe to:
Posts (Atom)