Hi All
I have a From and a To Date in a SQL Server 2005 Reporting Services Report.
How do I go about restricting the To Date so that is can't be less than the
From Date and also so the To Date is no more than 12 months greater than the
From Date?
ThanksOn Jun 24, 10:24 pm, David <D...@.discussions.microsoft.com> wrote:
> Hi All
> I have a From and a To Date in a SQL Server 2005 Reporting Services Report.
> How do I go about restricting the To Date so that is can't be less than the
> From Date and also so the To Date is no more than 12 months greater than the
> From Date?
> Thanks
If my memory servers me correctly, I think the only way to have this
kind of control of granularity (limiting dates), you will need to
create custom report parameters based on a dataset(s). Sorry that I
could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant
Showing posts with label services. Show all posts
Showing posts with label services. Show all posts
Wednesday, March 28, 2012
Wednesday, March 21, 2012
Restoring security access using rsconfig?
Hi,
I have accidentally removed myself from the Home folder of my local
installation of reporting services. My security group was using an old
domain group and RS warned me that it was invalid. I deleted the entry
which was Content Manager, thinking that I was in the
BuiltIn/Administrators group and therefore would still have access to
localhost/reports. Unfortunately, I realised that I was not in the
administrators group on my PC (A company policy), so I lost all access
to my reports deployment. However, when I got added to the local
administrators group, I found that I still did not have access to the
Reports website.
My question is: Is there a way to manually add a user as a Content
Manager without using the http://localhost/Reports website? I seem to
recall a possible way using rsconfig, but have not been able to find a
relevant posting. I really do not want to uninstall and reinstall RS.
Thanks!To reply to myself in case other people ever have this problem:
I don't think you can do it with rsconfig.
In the end, I went into the ReportServer database and looked at the
users, roles and policies tables.
I found a user that was in the database as a Content Manager
(builtin/administrators is usually in there by default, but I had
another user there).
I then edited the PolicyUserRole table to change the user_id for a user
that had Content Manager access and a policy of "0" for my own user.
This let me back into the localhost/reports page where I then added my
domain name again. If you don't have a Content Manager already, take
the guid for that role and paste it into your role.
If I didn't have a user in there, I assume I could just add one, but I
am unsure about the generation of the guid.
I don't know what the official way to do this is, but as a hack, it
worked.
MDXQuery wrote:
> Hi,
> I have accidentally removed myself from the Home folder of my local
> installation of reporting services. My security group was using an old
> domain group and RS warned me that it was invalid. I deleted the entry
> which was Content Manager, thinking that I was in the
> BuiltIn/Administrators group and therefore would still have access to
> localhost/reports. Unfortunately, I realised that I was not in the
> administrators group on my PC (A company policy), so I lost all access
> to my reports deployment. However, when I got added to the local
> administrators group, I found that I still did not have access to the
> Reports website.
> My question is: Is there a way to manually add a user as a Content
> Manager without using the http://localhost/Reports website? I seem to
> recall a possible way using rsconfig, but have not been able to find a
> relevant posting. I really do not want to uninstall and reinstall RS.
> Thanks!|||If you can add yourself to the local admininstrator role of the server that
RS resides on, then you will automatically have all the rights you need with
RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MDXQuery" <imgroup1@.hotmail.com> wrote in message
news:1125056826.979578.163790@.g43g2000cwa.googlegroups.com...
> To reply to myself in case other people ever have this problem:
> I don't think you can do it with rsconfig.
> In the end, I went into the ReportServer database and looked at the
> users, roles and policies tables.
> I found a user that was in the database as a Content Manager
> (builtin/administrators is usually in there by default, but I had
> another user there).
> I then edited the PolicyUserRole table to change the user_id for a user
> that had Content Manager access and a policy of "0" for my own user.
> This let me back into the localhost/reports page where I then added my
> domain name again. If you don't have a Content Manager already, take
> the guid for that role and paste it into your role.
> If I didn't have a user in there, I assume I could just add one, but I
> am unsure about the generation of the guid.
> I don't know what the official way to do this is, but as a hack, it
> worked.
>
>
> MDXQuery wrote:
>> Hi,
>> I have accidentally removed myself from the Home folder of my local
>> installation of reporting services. My security group was using an old
>> domain group and RS warned me that it was invalid. I deleted the entry
>> which was Content Manager, thinking that I was in the
>> BuiltIn/Administrators group and therefore would still have access to
>> localhost/reports. Unfortunately, I realised that I was not in the
>> administrators group on my PC (A company policy), so I lost all access
>> to my reports deployment. However, when I got added to the local
>> administrators group, I found that I still did not have access to the
>> Reports website.
>> My question is: Is there a way to manually add a user as a Content
>> Manager without using the http://localhost/Reports website? I seem to
>> recall a possible way using rsconfig, but have not been able to find a
>> relevant posting. I really do not want to uninstall and reinstall RS.
>> Thanks!
>
I have accidentally removed myself from the Home folder of my local
installation of reporting services. My security group was using an old
domain group and RS warned me that it was invalid. I deleted the entry
which was Content Manager, thinking that I was in the
BuiltIn/Administrators group and therefore would still have access to
localhost/reports. Unfortunately, I realised that I was not in the
administrators group on my PC (A company policy), so I lost all access
to my reports deployment. However, when I got added to the local
administrators group, I found that I still did not have access to the
Reports website.
My question is: Is there a way to manually add a user as a Content
Manager without using the http://localhost/Reports website? I seem to
recall a possible way using rsconfig, but have not been able to find a
relevant posting. I really do not want to uninstall and reinstall RS.
Thanks!To reply to myself in case other people ever have this problem:
I don't think you can do it with rsconfig.
In the end, I went into the ReportServer database and looked at the
users, roles and policies tables.
I found a user that was in the database as a Content Manager
(builtin/administrators is usually in there by default, but I had
another user there).
I then edited the PolicyUserRole table to change the user_id for a user
that had Content Manager access and a policy of "0" for my own user.
This let me back into the localhost/reports page where I then added my
domain name again. If you don't have a Content Manager already, take
the guid for that role and paste it into your role.
If I didn't have a user in there, I assume I could just add one, but I
am unsure about the generation of the guid.
I don't know what the official way to do this is, but as a hack, it
worked.
MDXQuery wrote:
> Hi,
> I have accidentally removed myself from the Home folder of my local
> installation of reporting services. My security group was using an old
> domain group and RS warned me that it was invalid. I deleted the entry
> which was Content Manager, thinking that I was in the
> BuiltIn/Administrators group and therefore would still have access to
> localhost/reports. Unfortunately, I realised that I was not in the
> administrators group on my PC (A company policy), so I lost all access
> to my reports deployment. However, when I got added to the local
> administrators group, I found that I still did not have access to the
> Reports website.
> My question is: Is there a way to manually add a user as a Content
> Manager without using the http://localhost/Reports website? I seem to
> recall a possible way using rsconfig, but have not been able to find a
> relevant posting. I really do not want to uninstall and reinstall RS.
> Thanks!|||If you can add yourself to the local admininstrator role of the server that
RS resides on, then you will automatically have all the rights you need with
RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MDXQuery" <imgroup1@.hotmail.com> wrote in message
news:1125056826.979578.163790@.g43g2000cwa.googlegroups.com...
> To reply to myself in case other people ever have this problem:
> I don't think you can do it with rsconfig.
> In the end, I went into the ReportServer database and looked at the
> users, roles and policies tables.
> I found a user that was in the database as a Content Manager
> (builtin/administrators is usually in there by default, but I had
> another user there).
> I then edited the PolicyUserRole table to change the user_id for a user
> that had Content Manager access and a policy of "0" for my own user.
> This let me back into the localhost/reports page where I then added my
> domain name again. If you don't have a Content Manager already, take
> the guid for that role and paste it into your role.
> If I didn't have a user in there, I assume I could just add one, but I
> am unsure about the generation of the guid.
> I don't know what the official way to do this is, but as a hack, it
> worked.
>
>
> MDXQuery wrote:
>> Hi,
>> I have accidentally removed myself from the Home folder of my local
>> installation of reporting services. My security group was using an old
>> domain group and RS warned me that it was invalid. I deleted the entry
>> which was Content Manager, thinking that I was in the
>> BuiltIn/Administrators group and therefore would still have access to
>> localhost/reports. Unfortunately, I realised that I was not in the
>> administrators group on my PC (A company policy), so I lost all access
>> to my reports deployment. However, when I got added to the local
>> administrators group, I found that I still did not have access to the
>> Reports website.
>> My question is: Is there a way to manually add a user as a Content
>> Manager without using the http://localhost/Reports website? I seem to
>> recall a possible way using rsconfig, but have not been able to find a
>> relevant posting. I really do not want to uninstall and reinstall RS.
>> Thanks!
>
Monday, March 12, 2012
restoring master database - single user mode
I am trying to restore a backup of a master database from one server to a
new server.
I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a command
prompt to start it in single user mode. It finished with "SQL Global
counter collection task is created." It appears to stop at this point -
there is no prompt.
While in single-user mode, I open Query Analyzer and attempt to log in both
with Windows Authentication and with SQL Server authentication, using the sa
login.
In both cases, I get an error "Login failed for user '(login)'. Reason:
Server is in single user mode. Only one administrator can connect at this
time."
Thanks for any suggestions.
-BillThere might be an EM connection that is already open.
"bill" <belgie@.datamti.com> wrote in message
news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> I am trying to restore a backup of a master database from one server to a
> new server.
> I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
command
> prompt to start it in single user mode. It finished with "SQL Global
> counter collection task is created." It appears to stop at this point -
> there is no prompt.
> While in single-user mode, I open Query Analyzer and attempt to log in
both
> with Windows Authentication and with SQL Server authentication, using the
sa
> login.
> In both cases, I get an error "Login failed for user '(login)'. Reason:
> Server is in single user mode. Only one administrator can connect at this
> time."
> Thanks for any suggestions.
> -Bill
>|||Good thought, but that's not it.
Thanks!
"Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> There might be an EM connection that is already open.
> "bill" <belgie@.datamti.com> wrote in message
> news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
a[vbcol=seagreen]
> command
> both
the[vbcol=seagreen]
> sa
this[vbcol=seagreen]
>|||Agent? Other services or users? You need to find who is connected...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> Good thought, but that's not it.
> Thanks!
> "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
> news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> a
> the
> this
>|||How can I do this? I can't connect to SQL Server to see the connections.
Thanks
Bill
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
> Agent? Other services or users? You need to find who is connected...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "bill" <belgie@.datamti.com> wrote in message
news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
to[vbcol=seagreen]
Global[vbcol=seagreen]
point -[vbcol=seagreen]
in[vbcol=seagreen]
using[vbcol=seagreen]
Reason:[vbcol=seagreen]
>|||Start stopping SQL server Agent, and other possible services that might use
SQL server. You might
need to get physical access to the machine, or terminal services, so you can
work locally on the
machine stopping services and perhaps even disabling network access (which i
sn't doable over
terminal services, of course).
Another thing you can try is to login using OSQL.EXE instead of Query Analyz
er. QA *might* try to
open a connection for Object Browser and that *might* get connected before y
our query window.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:emBg4NEuEHA.348@.tk2msftngp13.phx.gbl...[vb
col=seagreen]
> How can I do this? I can't connect to SQL Server to see the connections.
> Thanks
> Bill
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
> news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> to
> Global
> point -
> in
> using
> Reason:
>[/vbcol]
new server.
I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a command
prompt to start it in single user mode. It finished with "SQL Global
counter collection task is created." It appears to stop at this point -
there is no prompt.
While in single-user mode, I open Query Analyzer and attempt to log in both
with Windows Authentication and with SQL Server authentication, using the sa
login.
In both cases, I get an error "Login failed for user '(login)'. Reason:
Server is in single user mode. Only one administrator can connect at this
time."
Thanks for any suggestions.
-BillThere might be an EM connection that is already open.
"bill" <belgie@.datamti.com> wrote in message
news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> I am trying to restore a backup of a master database from one server to a
> new server.
> I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
command
> prompt to start it in single user mode. It finished with "SQL Global
> counter collection task is created." It appears to stop at this point -
> there is no prompt.
> While in single-user mode, I open Query Analyzer and attempt to log in
both
> with Windows Authentication and with SQL Server authentication, using the
sa
> login.
> In both cases, I get an error "Login failed for user '(login)'. Reason:
> Server is in single user mode. Only one administrator can connect at this
> time."
> Thanks for any suggestions.
> -Bill
>|||Good thought, but that's not it.
Thanks!
"Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> There might be an EM connection that is already open.
> "bill" <belgie@.datamti.com> wrote in message
> news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
a[vbcol=seagreen]
> command
> both
the[vbcol=seagreen]
> sa
this[vbcol=seagreen]
>|||Agent? Other services or users? You need to find who is connected...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> Good thought, but that's not it.
> Thanks!
> "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
> news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> a
> the
> this
>|||How can I do this? I can't connect to SQL Server to see the connections.
Thanks
Bill
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
> Agent? Other services or users? You need to find who is connected...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "bill" <belgie@.datamti.com> wrote in message
news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
to[vbcol=seagreen]
Global[vbcol=seagreen]
point -[vbcol=seagreen]
in[vbcol=seagreen]
using[vbcol=seagreen]
Reason:[vbcol=seagreen]
>|||Start stopping SQL server Agent, and other possible services that might use
SQL server. You might
need to get physical access to the machine, or terminal services, so you can
work locally on the
machine stopping services and perhaps even disabling network access (which i
sn't doable over
terminal services, of course).
Another thing you can try is to login using OSQL.EXE instead of Query Analyz
er. QA *might* try to
open a connection for Object Browser and that *might* get connected before y
our query window.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:emBg4NEuEHA.348@.tk2msftngp13.phx.gbl...[vb
col=seagreen]
> How can I do this? I can't connect to SQL Server to see the connections.
> Thanks
> Bill
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
> news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> to
> Global
> point -
> in
> using
> Reason:
>[/vbcol]
restoring master database - single user mode
I am trying to restore a backup of a master database from one server to a
new server.
I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a command
prompt to start it in single user mode. It finished with "SQL Global
counter collection task is created." It appears to stop at this point -
there is no prompt.
While in single-user mode, I open Query Analyzer and attempt to log in both
with Windows Authentication and with SQL Server authentication, using the sa
login.
In both cases, I get an error "Login failed for user '(login)'. Reason:
Server is in single user mode. Only one administrator can connect at this
time."
Thanks for any suggestions.
-Bill
There might be an EM connection that is already open.
"bill" <belgie@.datamti.com> wrote in message
news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> I am trying to restore a backup of a master database from one server to a
> new server.
> I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
command
> prompt to start it in single user mode. It finished with "SQL Global
> counter collection task is created." It appears to stop at this point -
> there is no prompt.
> While in single-user mode, I open Query Analyzer and attempt to log in
both
> with Windows Authentication and with SQL Server authentication, using the
sa
> login.
> In both cases, I get an error "Login failed for user '(login)'. Reason:
> Server is in single user mode. Only one administrator can connect at this
> time."
> Thanks for any suggestions.
> -Bill
>
|||Good thought, but that's not it.
Thanks!
"Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> There might be an EM connection that is already open.
> "bill" <belgie@.datamti.com> wrote in message
> news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
a[vbcol=seagreen]
> command
> both
the[vbcol=seagreen]
> sa
this
>
|||Agent? Other services or users? You need to find who is connected...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> Good thought, but that's not it.
> Thanks!
> "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
> news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> a
> the
> this
>
|||How can I do this? I can't connect to SQL Server to see the connections.
Thanks
Bill
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
> Agent? Other services or users? You need to find who is connected...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "bill" <belgie@.datamti.com> wrote in message
news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
to[vbcol=seagreen]
Global[vbcol=seagreen]
point -[vbcol=seagreen]
in[vbcol=seagreen]
using[vbcol=seagreen]
Reason:
>
|||Start stopping SQL server Agent, and other possible services that might use SQL server. You might
need to get physical access to the machine, or terminal services, so you can work locally on the
machine stopping services and perhaps even disabling network access (which isn't doable over
terminal services, of course).
Another thing you can try is to login using OSQL.EXE instead of Query Analyzer. QA *might* try to
open a connection for Object Browser and that *might* get connected before your query window.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:emBg4NEuEHA.348@.tk2msftngp13.phx.gbl...
> How can I do this? I can't connect to SQL Server to see the connections.
> Thanks
> Bill
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
> news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> to
> Global
> point -
> in
> using
> Reason:
>
new server.
I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a command
prompt to start it in single user mode. It finished with "SQL Global
counter collection task is created." It appears to stop at this point -
there is no prompt.
While in single-user mode, I open Query Analyzer and attempt to log in both
with Windows Authentication and with SQL Server authentication, using the sa
login.
In both cases, I get an error "Login failed for user '(login)'. Reason:
Server is in single user mode. Only one administrator can connect at this
time."
Thanks for any suggestions.
-Bill
There might be an EM connection that is already open.
"bill" <belgie@.datamti.com> wrote in message
news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> I am trying to restore a backup of a master database from one server to a
> new server.
> I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
command
> prompt to start it in single user mode. It finished with "SQL Global
> counter collection task is created." It appears to stop at this point -
> there is no prompt.
> While in single-user mode, I open Query Analyzer and attempt to log in
both
> with Windows Authentication and with SQL Server authentication, using the
sa
> login.
> In both cases, I get an error "Login failed for user '(login)'. Reason:
> Server is in single user mode. Only one administrator can connect at this
> time."
> Thanks for any suggestions.
> -Bill
>
|||Good thought, but that's not it.
Thanks!
"Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> There might be an EM connection that is already open.
> "bill" <belgie@.datamti.com> wrote in message
> news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
a[vbcol=seagreen]
> command
> both
the[vbcol=seagreen]
> sa
this
>
|||Agent? Other services or users? You need to find who is connected...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> Good thought, but that's not it.
> Thanks!
> "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
> news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> a
> the
> this
>
|||How can I do this? I can't connect to SQL Server to see the connections.
Thanks
Bill
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
> Agent? Other services or users? You need to find who is connected...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "bill" <belgie@.datamti.com> wrote in message
news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
to[vbcol=seagreen]
Global[vbcol=seagreen]
point -[vbcol=seagreen]
in[vbcol=seagreen]
using[vbcol=seagreen]
Reason:
>
|||Start stopping SQL server Agent, and other possible services that might use SQL server. You might
need to get physical access to the machine, or terminal services, so you can work locally on the
machine stopping services and perhaps even disabling network access (which isn't doable over
terminal services, of course).
Another thing you can try is to login using OSQL.EXE instead of Query Analyzer. QA *might* try to
open a connection for Object Browser and that *might* get connected before your query window.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:emBg4NEuEHA.348@.tk2msftngp13.phx.gbl...
> How can I do this? I can't connect to SQL Server to see the connections.
> Thanks
> Bill
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
> news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> to
> Global
> point -
> in
> using
> Reason:
>
restoring master database - single user mode
I am trying to restore a backup of a master database from one server to a
new server.
I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a command
prompt to start it in single user mode. It finished with "SQL Global
counter collection task is created." It appears to stop at this point -
there is no prompt.
While in single-user mode, I open Query Analyzer and attempt to log in both
with Windows Authentication and with SQL Server authentication, using the sa
login.
In both cases, I get an error "Login failed for user '(login)'. Reason:
Server is in single user mode. Only one administrator can connect at this
time."
Thanks for any suggestions.
-BillThere might be an EM connection that is already open.
"bill" <belgie@.datamti.com> wrote in message
news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> I am trying to restore a backup of a master database from one server to a
> new server.
> I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
command
> prompt to start it in single user mode. It finished with "SQL Global
> counter collection task is created." It appears to stop at this point -
> there is no prompt.
> While in single-user mode, I open Query Analyzer and attempt to log in
both
> with Windows Authentication and with SQL Server authentication, using the
sa
> login.
> In both cases, I get an error "Login failed for user '(login)'. Reason:
> Server is in single user mode. Only one administrator can connect at this
> time."
> Thanks for any suggestions.
> -Bill
>|||Good thought, but that's not it.
Thanks!
"Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> There might be an EM connection that is already open.
> "bill" <belgie@.datamti.com> wrote in message
> news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> > I am trying to restore a backup of a master database from one server to
a
> > new server.
> >
> > I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
> command
> > prompt to start it in single user mode. It finished with "SQL Global
> > counter collection task is created." It appears to stop at this point -
> > there is no prompt.
> >
> > While in single-user mode, I open Query Analyzer and attempt to log in
> both
> > with Windows Authentication and with SQL Server authentication, using
the
> sa
> > login.
> >
> > In both cases, I get an error "Login failed for user '(login)'. Reason:
> > Server is in single user mode. Only one administrator can connect at
this
> > time."
> >
> > Thanks for any suggestions.
> > -Bill
> >
> >
>|||Agent? Other services or users? You need to find who is connected...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> Good thought, but that's not it.
> Thanks!
> "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
> news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> > There might be an EM connection that is already open.
> >
> > "bill" <belgie@.datamti.com> wrote in message
> > news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> > > I am trying to restore a backup of a master database from one server to
> a
> > > new server.
> > >
> > > I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
> > command
> > > prompt to start it in single user mode. It finished with "SQL Global
> > > counter collection task is created." It appears to stop at this point -
> > > there is no prompt.
> > >
> > > While in single-user mode, I open Query Analyzer and attempt to log in
> > both
> > > with Windows Authentication and with SQL Server authentication, using
> the
> > sa
> > > login.
> > >
> > > In both cases, I get an error "Login failed for user '(login)'. Reason:
> > > Server is in single user mode. Only one administrator can connect at
> this
> > > time."
> > >
> > > Thanks for any suggestions.
> > > -Bill
> > >
> > >
> >
> >
>|||How can I do this? I can't connect to SQL Server to see the connections.
Thanks
Bill
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
> Agent? Other services or users? You need to find who is connected...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "bill" <belgie@.datamti.com> wrote in message
news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> > Good thought, but that's not it.
> >
> > Thanks!
> >
> > "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
> > news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> > > There might be an EM connection that is already open.
> > >
> > > "bill" <belgie@.datamti.com> wrote in message
> > > news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> > > > I am trying to restore a backup of a master database from one server
to
> > a
> > > > new server.
> > > >
> > > > I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
> > > command
> > > > prompt to start it in single user mode. It finished with "SQL
Global
> > > > counter collection task is created." It appears to stop at this
point -
> > > > there is no prompt.
> > > >
> > > > While in single-user mode, I open Query Analyzer and attempt to log
in
> > > both
> > > > with Windows Authentication and with SQL Server authentication,
using
> > the
> > > sa
> > > > login.
> > > >
> > > > In both cases, I get an error "Login failed for user '(login)'.
Reason:
> > > > Server is in single user mode. Only one administrator can connect at
> > this
> > > > time."
> > > >
> > > > Thanks for any suggestions.
> > > > -Bill
> > > >
> > > >
> > >
> > >
> >
> >
>|||Start stopping SQL server Agent, and other possible services that might use SQL server. You might
need to get physical access to the machine, or terminal services, so you can work locally on the
machine stopping services and perhaps even disabling network access (which isn't doable over
terminal services, of course).
Another thing you can try is to login using OSQL.EXE instead of Query Analyzer. QA *might* try to
open a connection for Object Browser and that *might* get connected before your query window.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:emBg4NEuEHA.348@.tk2msftngp13.phx.gbl...
> How can I do this? I can't connect to SQL Server to see the connections.
> Thanks
> Bill
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
>> Agent? Other services or users? You need to find who is connected...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "bill" <belgie@.datamti.com> wrote in message
> news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
>> > Good thought, but that's not it.
>> >
>> > Thanks!
>> >
>> > "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
>> > news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
>> > > There might be an EM connection that is already open.
>> > >
>> > > "bill" <belgie@.datamti.com> wrote in message
>> > > news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
>> > > > I am trying to restore a backup of a master database from one server
> to
>> > a
>> > > > new server.
>> > > >
>> > > > I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
>> > > command
>> > > > prompt to start it in single user mode. It finished with "SQL
> Global
>> > > > counter collection task is created." It appears to stop at this
> point -
>> > > > there is no prompt.
>> > > >
>> > > > While in single-user mode, I open Query Analyzer and attempt to log
> in
>> > > both
>> > > > with Windows Authentication and with SQL Server authentication,
> using
>> > the
>> > > sa
>> > > > login.
>> > > >
>> > > > In both cases, I get an error "Login failed for user '(login)'.
> Reason:
>> > > > Server is in single user mode. Only one administrator can connect at
>> > this
>> > > > time."
>> > > >
>> > > > Thanks for any suggestions.
>> > > > -Bill
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>
new server.
I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a command
prompt to start it in single user mode. It finished with "SQL Global
counter collection task is created." It appears to stop at this point -
there is no prompt.
While in single-user mode, I open Query Analyzer and attempt to log in both
with Windows Authentication and with SQL Server authentication, using the sa
login.
In both cases, I get an error "Login failed for user '(login)'. Reason:
Server is in single user mode. Only one administrator can connect at this
time."
Thanks for any suggestions.
-BillThere might be an EM connection that is already open.
"bill" <belgie@.datamti.com> wrote in message
news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> I am trying to restore a backup of a master database from one server to a
> new server.
> I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
command
> prompt to start it in single user mode. It finished with "SQL Global
> counter collection task is created." It appears to stop at this point -
> there is no prompt.
> While in single-user mode, I open Query Analyzer and attempt to log in
both
> with Windows Authentication and with SQL Server authentication, using the
sa
> login.
> In both cases, I get an error "Login failed for user '(login)'. Reason:
> Server is in single user mode. Only one administrator can connect at this
> time."
> Thanks for any suggestions.
> -Bill
>|||Good thought, but that's not it.
Thanks!
"Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> There might be an EM connection that is already open.
> "bill" <belgie@.datamti.com> wrote in message
> news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> > I am trying to restore a backup of a master database from one server to
a
> > new server.
> >
> > I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
> command
> > prompt to start it in single user mode. It finished with "SQL Global
> > counter collection task is created." It appears to stop at this point -
> > there is no prompt.
> >
> > While in single-user mode, I open Query Analyzer and attempt to log in
> both
> > with Windows Authentication and with SQL Server authentication, using
the
> sa
> > login.
> >
> > In both cases, I get an error "Login failed for user '(login)'. Reason:
> > Server is in single user mode. Only one administrator can connect at
this
> > time."
> >
> > Thanks for any suggestions.
> > -Bill
> >
> >
>|||Agent? Other services or users? You need to find who is connected...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> Good thought, but that's not it.
> Thanks!
> "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
> news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> > There might be an EM connection that is already open.
> >
> > "bill" <belgie@.datamti.com> wrote in message
> > news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> > > I am trying to restore a backup of a master database from one server to
> a
> > > new server.
> > >
> > > I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
> > command
> > > prompt to start it in single user mode. It finished with "SQL Global
> > > counter collection task is created." It appears to stop at this point -
> > > there is no prompt.
> > >
> > > While in single-user mode, I open Query Analyzer and attempt to log in
> > both
> > > with Windows Authentication and with SQL Server authentication, using
> the
> > sa
> > > login.
> > >
> > > In both cases, I get an error "Login failed for user '(login)'. Reason:
> > > Server is in single user mode. Only one administrator can connect at
> this
> > > time."
> > >
> > > Thanks for any suggestions.
> > > -Bill
> > >
> > >
> >
> >
>|||How can I do this? I can't connect to SQL Server to see the connections.
Thanks
Bill
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
> Agent? Other services or users? You need to find who is connected...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "bill" <belgie@.datamti.com> wrote in message
news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> > Good thought, but that's not it.
> >
> > Thanks!
> >
> > "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
> > news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> > > There might be an EM connection that is already open.
> > >
> > > "bill" <belgie@.datamti.com> wrote in message
> > > news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> > > > I am trying to restore a backup of a master database from one server
to
> > a
> > > > new server.
> > > >
> > > > I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
> > > command
> > > > prompt to start it in single user mode. It finished with "SQL
Global
> > > > counter collection task is created." It appears to stop at this
point -
> > > > there is no prompt.
> > > >
> > > > While in single-user mode, I open Query Analyzer and attempt to log
in
> > > both
> > > > with Windows Authentication and with SQL Server authentication,
using
> > the
> > > sa
> > > > login.
> > > >
> > > > In both cases, I get an error "Login failed for user '(login)'.
Reason:
> > > > Server is in single user mode. Only one administrator can connect at
> > this
> > > > time."
> > > >
> > > > Thanks for any suggestions.
> > > > -Bill
> > > >
> > > >
> > >
> > >
> >
> >
>|||Start stopping SQL server Agent, and other possible services that might use SQL server. You might
need to get physical access to the machine, or terminal services, so you can work locally on the
machine stopping services and perhaps even disabling network access (which isn't doable over
terminal services, of course).
Another thing you can try is to login using OSQL.EXE instead of Query Analyzer. QA *might* try to
open a connection for Object Browser and that *might* get connected before your query window.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:emBg4NEuEHA.348@.tk2msftngp13.phx.gbl...
> How can I do this? I can't connect to SQL Server to see the connections.
> Thanks
> Bill
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
>> Agent? Other services or users? You need to find who is connected...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "bill" <belgie@.datamti.com> wrote in message
> news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
>> > Good thought, but that's not it.
>> >
>> > Thanks!
>> >
>> > "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
>> > news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
>> > > There might be an EM connection that is already open.
>> > >
>> > > "bill" <belgie@.datamti.com> wrote in message
>> > > news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
>> > > > I am trying to restore a backup of a master database from one server
> to
>> > a
>> > > > new server.
>> > > >
>> > > > I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
>> > > command
>> > > > prompt to start it in single user mode. It finished with "SQL
> Global
>> > > > counter collection task is created." It appears to stop at this
> point -
>> > > > there is no prompt.
>> > > >
>> > > > While in single-user mode, I open Query Analyzer and attempt to log
> in
>> > > both
>> > > > with Windows Authentication and with SQL Server authentication,
> using
>> > the
>> > > sa
>> > > > login.
>> > > >
>> > > > In both cases, I get an error "Login failed for user '(login)'.
> Reason:
>> > > > Server is in single user mode. Only one administrator can connect at
>> > this
>> > > > time."
>> > > >
>> > > > Thanks for any suggestions.
>> > > > -Bill
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>
Friday, March 9, 2012
restoring from network drive
Ok -I'm drawing a huge blank.
After a new install of SQL2K and SP3a, I'm unable to restore a backup from a
network drive.
SQL services are logging on with a domain account
The SQL service account has also been granted Local admin access on the PC
When trying to restore a database from Device, the only drive listed is the
local C: drive - none of the mapped drives are available.
JTTry entering a UNC name for the name of the backup, something like:
\\backupserver\sharename\backup\database
.bak
Also note the MSSQLSERVER service account will need access to the network
share.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"JT" <JT_*n*o*s*p*a*m*Goalie33@.cox.net> wrote in message
news:WAZzc.4489$cj3.1501@.lakeread01...
> Ok -I'm drawing a huge blank.
> After a new install of SQL2K and SP3a, I'm unable to restore a backup from
a
> network drive.
> SQL services are logging on with a domain account
> The SQL service account has also been granted Local admin access on the PC
> When trying to restore a database from Device, the only drive listed is
the
> local C: drive - none of the mapped drives are available.
> JT
>
After a new install of SQL2K and SP3a, I'm unable to restore a backup from a
network drive.
SQL services are logging on with a domain account
The SQL service account has also been granted Local admin access on the PC
When trying to restore a database from Device, the only drive listed is the
local C: drive - none of the mapped drives are available.
JTTry entering a UNC name for the name of the backup, something like:
\\backupserver\sharename\backup\database
.bak
Also note the MSSQLSERVER service account will need access to the network
share.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"JT" <JT_*n*o*s*p*a*m*Goalie33@.cox.net> wrote in message
news:WAZzc.4489$cj3.1501@.lakeread01...
> Ok -I'm drawing a huge blank.
> After a new install of SQL2K and SP3a, I'm unable to restore a backup from
a
> network drive.
> SQL services are logging on with a domain account
> The SQL service account has also been granted Local admin access on the PC
> When trying to restore a database from Device, the only drive listed is
the
> local C: drive - none of the mapped drives are available.
> JT
>
restoring from network drive
Ok -I'm drawing a huge blank.
After a new install of SQL2K and SP3a, I'm unable to restore a backup from a
network drive.
SQL services are logging on with a domain account
The SQL service account has also been granted Local admin access on the PC
When trying to restore a database from Device, the only drive listed is the
local C: drive - none of the mapped drives are available.
JT
Try entering a UNC name for the name of the backup, something like:
\\backupserver\sharename\backup\database.bak
Also note the MSSQLSERVER service account will need access to the network
share.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"JT" <JT_*n*o*s*p*a*m*Goalie33@.cox.net> wrote in message
news:WAZzc.4489$cj3.1501@.lakeread01...
> Ok -I'm drawing a huge blank.
> After a new install of SQL2K and SP3a, I'm unable to restore a backup from
a
> network drive.
> SQL services are logging on with a domain account
> The SQL service account has also been granted Local admin access on the PC
> When trying to restore a database from Device, the only drive listed is
the
> local C: drive - none of the mapped drives are available.
> JT
>
After a new install of SQL2K and SP3a, I'm unable to restore a backup from a
network drive.
SQL services are logging on with a domain account
The SQL service account has also been granted Local admin access on the PC
When trying to restore a database from Device, the only drive listed is the
local C: drive - none of the mapped drives are available.
JT
Try entering a UNC name for the name of the backup, something like:
\\backupserver\sharename\backup\database.bak
Also note the MSSQLSERVER service account will need access to the network
share.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"JT" <JT_*n*o*s*p*a*m*Goalie33@.cox.net> wrote in message
news:WAZzc.4489$cj3.1501@.lakeread01...
> Ok -I'm drawing a huge blank.
> After a new install of SQL2K and SP3a, I'm unable to restore a backup from
a
> network drive.
> SQL services are logging on with a domain account
> The SQL service account has also been granted Local admin access on the PC
> When trying to restore a database from Device, the only drive listed is
the
> local C: drive - none of the mapped drives are available.
> JT
>
restoring from network drive
Ok -I'm drawing a huge blank.
After a new install of SQL2K and SP3a, I'm unable to restore a backup from a
network drive.
SQL services are logging on with a domain account
The SQL service account has also been granted Local admin access on the PC
When trying to restore a database from Device, the only drive listed is the
local C: drive - none of the mapped drives are available.
JTTry entering a UNC name for the name of the backup, something like:
\\backupserver\sharename\backup\database.bak
Also note the MSSQLSERVER service account will need access to the network
share.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"JT" <JT_*n*o*s*p*a*m*Goalie33@.cox.net> wrote in message
news:WAZzc.4489$cj3.1501@.lakeread01...
> Ok -I'm drawing a huge blank.
> After a new install of SQL2K and SP3a, I'm unable to restore a backup from
a
> network drive.
> SQL services are logging on with a domain account
> The SQL service account has also been granted Local admin access on the PC
> When trying to restore a database from Device, the only drive listed is
the
> local C: drive - none of the mapped drives are available.
> JT
>|||SQL Server will only show local drives/partitions on the
computer you are trying to restore to...Use UNC names/IP
adresses when restoring from a network drive.
EX:
RESTORE DATABASE MYDATABASE
FROM DISK = '\\SERVER1\D$\Program Files\Microsoft SQL
Server\MSSQL\Backup\MYDATABASE\MYDATABASE.BAK'
WITH
DBO_ONLY,
REPLACE,
STANDBY = '\\SERVER1\D$\Program Files\Microsoft SQL
Server\MSSQL\Backup\MYDATABASE\'UNDO_MYDATABASE.ldf',
MOVE 'MYDATABASE_Data' TO 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\MYDATABASE_Data.mdf',
MOVE 'MYDATABASE_Log' TO 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\MYDATABASE_Log.ldf'
e.t.c
>--Original Message--
>Ok -I'm drawing a huge blank.
>After a new install of SQL2K and SP3a, I'm unable to
restore a backup from a
>network drive.
>SQL services are logging on with a domain account
>The SQL service account has also been granted Local admin
access on the PC
>When trying to restore a database from Device, the only
drive listed is the
>local C: drive - none of the mapped drives are available.
>JT
>
>.
>
After a new install of SQL2K and SP3a, I'm unable to restore a backup from a
network drive.
SQL services are logging on with a domain account
The SQL service account has also been granted Local admin access on the PC
When trying to restore a database from Device, the only drive listed is the
local C: drive - none of the mapped drives are available.
JTTry entering a UNC name for the name of the backup, something like:
\\backupserver\sharename\backup\database.bak
Also note the MSSQLSERVER service account will need access to the network
share.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"JT" <JT_*n*o*s*p*a*m*Goalie33@.cox.net> wrote in message
news:WAZzc.4489$cj3.1501@.lakeread01...
> Ok -I'm drawing a huge blank.
> After a new install of SQL2K and SP3a, I'm unable to restore a backup from
a
> network drive.
> SQL services are logging on with a domain account
> The SQL service account has also been granted Local admin access on the PC
> When trying to restore a database from Device, the only drive listed is
the
> local C: drive - none of the mapped drives are available.
> JT
>|||SQL Server will only show local drives/partitions on the
computer you are trying to restore to...Use UNC names/IP
adresses when restoring from a network drive.
EX:
RESTORE DATABASE MYDATABASE
FROM DISK = '\\SERVER1\D$\Program Files\Microsoft SQL
Server\MSSQL\Backup\MYDATABASE\MYDATABASE.BAK'
WITH
DBO_ONLY,
REPLACE,
STANDBY = '\\SERVER1\D$\Program Files\Microsoft SQL
Server\MSSQL\Backup\MYDATABASE\'UNDO_MYDATABASE.ldf',
MOVE 'MYDATABASE_Data' TO 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\MYDATABASE_Data.mdf',
MOVE 'MYDATABASE_Log' TO 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\MYDATABASE_Log.ldf'
e.t.c
>--Original Message--
>Ok -I'm drawing a huge blank.
>After a new install of SQL2K and SP3a, I'm unable to
restore a backup from a
>network drive.
>SQL services are logging on with a domain account
>The SQL service account has also been granted Local admin
access on the PC
>When trying to restore a database from Device, the only
drive listed is the
>local C: drive - none of the mapped drives are available.
>JT
>
>.
>
Saturday, February 25, 2012
Restoring differential backups
Hi
We did a full backup of a DB on Server A (SQL Server 2000) and restored it on Server B (SQL server 2005). Since we have Notification Services, so we run nscontrol upgrade command to upgrade it to 2005. We want to test our application by pointing test server to Server B, while our live application is running by still pointing to Server A.
Now we want to make the states of Server A and B in sync. What can be the best approach for this, since during upgrade some data gets modified. Will differential backup work in this scenario?
Please help me.
Thanks,
Gagan
Unfortunately differential backup does not work across the sql2000->sql2005 upgrade.
Before taking differential backups in sql2005, a new full backup is required.
However, when using the FULL/BULK recovery models, you can use log backups to rollforward thru the upgrade.
Be aware that until server A is upgraded to sql2005, no backups taken from server B (now at sql2005) can be restored.
Hope that helps.
Subscribe to:
Posts (Atom)