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 rename. Show all posts
Showing posts with label rename. 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
>
>
Tuesday, February 14, 2012
Can't connect to Reporting Services after I rename my computer
Hi,
I have installed SQL 2005 on my Windows 2003 box. After I install SQL
2005, I have configured the Reporting Services and I can connect using
the Management Studio. I had to rename my machine and after I renamed I
can still connect to Database Services from Management Studio. However
I am getting error while I connect to Reporting Services. I have also
tried sp_dropserver <old> and sp_addserver <new>,'local'. It still
doesn't help.
Can someone help me out with fixing this issue.
Thanks,
Prasanna.Prasanna,
When I had the same problem, I ran RSConfig.exe.
Check it for the apprpriate paraemters.
Alan
<csoprasanna@.gmail.com> wrote in message
news:1147394767.664213.99720@.j33g2000cwa.googlegroups.com...
> Hi,
> I have installed SQL 2005 on my Windows 2003 box. After I install SQL
> 2005, I have configured the Reporting Services and I can connect using
> the Management Studio. I had to rename my machine and after I renamed I
> can still connect to Database Services from Management Studio. However
> I am getting error while I connect to Reporting Services. I have also
> tried sp_dropserver <old> and sp_addserver <new>,'local'. It still
> doesn't help.
> Can someone help me out with fixing this issue.
> Thanks,
> Prasanna.
>
I have installed SQL 2005 on my Windows 2003 box. After I install SQL
2005, I have configured the Reporting Services and I can connect using
the Management Studio. I had to rename my machine and after I renamed I
can still connect to Database Services from Management Studio. However
I am getting error while I connect to Reporting Services. I have also
tried sp_dropserver <old> and sp_addserver <new>,'local'. It still
doesn't help.
Can someone help me out with fixing this issue.
Thanks,
Prasanna.Prasanna,
When I had the same problem, I ran RSConfig.exe.
Check it for the apprpriate paraemters.
Alan
<csoprasanna@.gmail.com> wrote in message
news:1147394767.664213.99720@.j33g2000cwa.googlegroups.com...
> Hi,
> I have installed SQL 2005 on my Windows 2003 box. After I install SQL
> 2005, I have configured the Reporting Services and I can connect using
> the Management Studio. I had to rename my machine and after I renamed I
> can still connect to Database Services from Management Studio. However
> I am getting error while I connect to Reporting Services. I have also
> tried sp_dropserver <old> and sp_addserver <new>,'local'. It still
> doesn't help.
> Can someone help me out with fixing this issue.
> Thanks,
> Prasanna.
>
Subscribe to:
Posts (Atom)