Hi all,
Is there any way to have the report parameters appear in the subscription
email, for both custom and default reports? Currently, the goal is to just
get the team project name to appear along with the sent report. The other
idea I can think of is to just put a field in the actual report that will
show the project name. I would rather not do this so that we don't have to
edit the existing rdl's (unless in the end, we absolutely have to). It
would also appear redundant when viewing the reports through Report Manager.
In addition to these, it is possible that people would request for other
parameters to be sent with the email, thus cluttering the actual report with
redundant information.
Can anyone help or offer alternatives, please? Thanks.Hello Winkles,
I would like to know this issue a little bit clearly.
Do you mean that you want to add the Report Parameter in the Subject of the
subscription?
Well, you could not refer the Report Parameter in the Subject.
I would like to suggest you to use the data driven subscription so that you
could store the subject in a data table and you could maintain it.
Data-Driven Subscriptions
http://msdn2.microsoft.com/en-us/library/ms159150.aspx
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei,
We are trying to include, at the very least, the team project name in the
email somewhere. This is because some people may subscribe to the same
report across multiple team projects, and we need a way to indicate which
project the report belongs to.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:dllA96K$GHA.4432@.TK2MSFTNGXA01.phx.gbl...
> Hello Winkles,
> I would like to know this issue a little bit clearly.
> Do you mean that you want to add the Report Parameter in the Subject of
> the
> subscription?
> Well, you could not refer the Report Parameter in the Subject.
> I would like to suggest you to use the data driven subscription so that
> you
> could store the subject in a data table and you could maintain it.
> Data-Driven Subscriptions
> http://msdn2.microsoft.com/en-us/library/ms159150.aspx
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Winkles,
Thanks for the update.
When you try to create a subscription, you will need to provide which
parameter you will need to render the report.
According to your scenario, you could add a TextBox in the beginning of the
report and add the value =Parameters!Team.Value in the textbox. Then, when
you send the email, and provide the parameter value, it will show the value
in the report.
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei,
Thanks for your response. So is that the only way to do it then? Adding a
textbox to the report? There is no way to either set some flag or add some
lines of code to get something like the Parameters selection box to be sent
with the subscription email, along with the options used to generate that
report?
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:a8xSHiY$GHA.4184@.TK2MSFTNGXA01.phx.gbl...
> Hello Winkles,
> Thanks for the update.
> When you try to create a subscription, you will need to provide which
> parameter you will need to render the report.
> According to your scenario, you could add a TextBox in the beginning of
> the
> report and add the value =Parameters!Team.Value in the textbox. Then, when
> you send the email, and provide the parameter value, it will show the
> value
> in the report.
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Just to clarify: will this change also be applied to people who subscribe to
their own reports, i.e. independent of a data-driven subscription?
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:a8xSHiY$GHA.4184@.TK2MSFTNGXA01.phx.gbl...
> Hello Winkles,
> Thanks for the update.
> When you try to create a subscription, you will need to provide which
> parameter you will need to render the report.
> According to your scenario, you could add a TextBox in the beginning of
> the
> report and add the value =Parameters!Team.Value in the textbox. Then, when
> you send the email, and provide the parameter value, it will show the
> value
> in the report.
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Winkles,
If you wants the user to be able to select the parameter in the email
subscription, that can not been done in the Reporting Services.
All the report render type need a parameter value so you could not just
provide the parameter select option in the output file.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Showing posts with label default. Show all posts
Showing posts with label default. Show all posts
Thursday, February 16, 2012
Sunday, February 12, 2012
Can not start Report Builder!
I just setup my dev server of SQL 2005 including reporting service on Windows 2003 SP1. Basically all settings are default.
When I activiate Report Builder from local, it works fine. Everything runs smoothly. However, we I try to run Report Builder from a remote client, which is XP SP2. It always shows me the following error: "Application download did not succeed. Check your network connection, or contact your system administrator or network service provider." I don't think it's about permission issues. I am using the administrator group user. Besides the report builder activiation part, I can browser every part on report server website without error.
Do appreciate your help!!!
Details provided by server are
"PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
SOURCES
Deployment url : http://myserver/ReportServer/ReportBuilder/ReportBuilder.application
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://myserver/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://myserver/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (500) Internal Server Error.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [11/22/2005 10:13:33 AM] : Activation of http://myserver/ReportServer/ReportBuilder/ReportBuilder.application has started.
ERROR DETAILS
Following errors were detected during this operation.
* [11/22/2005 10:13:33 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://myserver/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
Inner Exception
System.Net.WebException
- The remote server returned an error: (500) Internal Server Error.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.
Weird part is I can launch Report Builder successfully from wireless laptop. But when I connected laptop back to wired network, same error came back. I suspect it's due to network settings.
Any one has the similar problem?|||
Having similar kind of issue. Error summary says this.
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://rs.mycompany.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://rs.mycompany.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ Unable to connect to the remote server
+ An established connection was aborted by the software in your host machine
It was working like Champ couple of days back. There has been some firewall policy changes happened between today and day it worked. I am suspecting something to do with firewall. But I am not sure. somebody please help.
Pleaseeee HELP!
Thanks,
Can not start Report Builder!
I just setup my dev server of SQL 2005 including reporting service on Windows 2003 SP1. Basically all settings are default.
When I activiate Report Builder from local, it works fine. Everything runs smoothly. However, we I try to run Report Builder from a remote client, which is XP SP2. It always shows me the following error: "Application download did not succeed. Check your network connection, or contact your system administrator or network service provider." I don't think it's about permission issues. I am using the administrator group user. Besides the report builder activiation part, I can browser every part on report server website without error.
Do appreciate your help!!!
Details provided by server are
"PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
SOURCES
Deployment url : http://myserver/ReportServer/ReportBuilder/ReportBuilder.application
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://myserver/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://myserver/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (500) Internal Server Error.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [11/22/2005 10:13:33 AM] : Activation of http://myserver/ReportServer/ReportBuilder/ReportBuilder.application has started.
ERROR DETAILS
Following errors were detected during this operation.
* [11/22/2005 10:13:33 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://myserver/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
Inner Exception
System.Net.WebException
- The remote server returned an error: (500) Internal Server Error.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.
Weird part is I can launch Report Builder successfully from wireless laptop. But when I connected laptop back to wired network, same error came back. I suspect it's due to network settings.
Any one has the similar problem?|||
Having similar kind of issue. Error summary says this.
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://rs.mycompany.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://rs.mycompany.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ Unable to connect to the remote server
+ An established connection was aborted by the software in your host machine
It was working like Champ couple of days back. There has been some firewall policy changes happened between today and day it worked. I am suspecting something to do with firewall. But I am not sure. somebody please help.
Pleaseeee HELP!
Thanks,
Friday, February 10, 2012
Can not open user default database.
I deattached my default DB and crashed on reattaching it. I now get the abo
ve error. I am using MS SQL 2000
Any suggestions or advice?
Thanks
ScottHi,
Can you please check whether the database is accessible.
1. Login as SA in query analyzer
2. execute the command
use dbname (replace database name with actual)
3. If you can open the database then no issues, otherwise send the error
you are getting after executing the command.
Thanks
Hari
MCDBA
"Scott Sheen" <anonymous@.discussions.microsoft.com> wrote in message
news:DA63BEEE-BF15-411E-89D1-654B42263897@.microsoft.com...
above error. I am using MS SQL 2000
Unable to connect to server ...
Server: Msg 4064, Level 16 State 1
Cannot open user default database. Login failed.
This is similiar and related to the error I am getting in enterprise manager
.
A connection could not be established to ...
Reason: Cannot open user default database. login failed..
...
I was coping over a DB file and when I started up the manage I had this erro
r.
I forgot the log file. I restored to my original version of that DB file.
I
then detached that db and tried to reattach the new version of the db (from
a
different PC) which failed and logged me out of the server. I figured that
was
because that DB was my default DB.
Thanks for your help.
Scott
"Hari" <hari_prasad_k@.hotmail.com> wrote:
eason you see now. The
default database for the user you are logging in as doesn't exist (for some
reason), which mean that
you cannot login! Actually ISQL.EXE and I think OSQL.EXE will let you in, so
use any of these tools
to login and then use sp_defaultdb to change the default database. Or, login
as another login which
work and let that login change the default database for you (that login need
to be sysadmin).
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Scott Sheen" <sasheen@.oanet.com> wrote in message news:OCbFYSu6DHA.3008@.TK2MSFTNGP09.phx.gbl...[Q
UOTE]
> I can not login to query analyzer.
> Unable to connect to server ...
> Server: Msg 4064, Level 16 State 1
> Cannot open user default database. Login failed.
> This is similiar and related to the error I am getting in enterprise manag
er.
> A connection could not be established to ...
> Reason: Cannot open user default database. login failed..
> ...
> I was coping over a DB file and when I started up the manage I had this er
ror.
> I forgot the log file. I restored to my original version of that DB file.
I
> then detached that db and tried to reattach the new version of the db (fro
m a
> different PC) which failed and logged me out of the server. I figured tha
t was
> because that DB was my default DB.
> Thanks for your help.
> Scott
> "Hari" <hari_prasad_k@.hotmail.com> wrote:
>[/QUOTE]|||Scott
Try give permissions to the def database by using
sp_grantdbaccess [@.loginame =] 'login'
[,[@.name_in_db =] 'name_in_db' [OUTPUT]]
OR
Drop the login and by using sp_addlogin create a new one with default
database access.
For more details please refer to BOL
"Scott Sheen" <sasheen@.oanet.com> wrote in message
news:OCbFYSu6DHA.3008@.TK2MSFTNGP09.phx.gbl...
manager.
error.
I
(from a
that was
ql
either.
I can not seem to recreate a new server and DB either as I get the same erro
r.
Anymore suggestions?
Best Regards,
Scott S.
"Uri Dimant" <urid@.iscar.co.il> wrote:
isql -E
will get me into iSQL. sp_defaultdb ' ...', 'master' will change the defa
ult
DB.
However, in my confusion late night I removed all the dbs under the server t
o
start over.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
n
created a new DB, made that the default and all was good.
Scott
ve error. I am using MS SQL 2000
Any suggestions or advice?
Thanks
ScottHi,
Can you please check whether the database is accessible.
1. Login as SA in query analyzer
2. execute the command
use dbname (replace database name with actual)
3. If you can open the database then no issues, otherwise send the error
you are getting after executing the command.
Thanks
Hari
MCDBA
"Scott Sheen" <anonymous@.discussions.microsoft.com> wrote in message
news:DA63BEEE-BF15-411E-89D1-654B42263897@.microsoft.com...
quote:
> I deattached my default DB and crashed on reattaching it. I now get the
above error. I am using MS SQL 2000
quote:|||I can not login to query analyzer.
> Any suggestions or advice?
> Thanks
> Scott
Unable to connect to server ...
Server: Msg 4064, Level 16 State 1
Cannot open user default database. Login failed.
This is similiar and related to the error I am getting in enterprise manager
.
A connection could not be established to ...
Reason: Cannot open user default database. login failed..
...
I was coping over a DB file and when I started up the manage I had this erro
r.
I forgot the log file. I restored to my original version of that DB file.
I
then detached that db and tried to reattach the new version of the db (from
a
different PC) which failed and logged me out of the server. I figured that
was
because that DB was my default DB.
Thanks for your help.
Scott
"Hari" <hari_prasad_k@.hotmail.com> wrote:
quote:|||I do not recommend changing the default database for sysadmins of the very r
>Hi,
>Can you please check whether the database is accessible.
>1. Login as SA in query analyzer
>2. execute the command
> use dbname (replace database name with actual)
>3. If you can open the database then no issues, otherwise send the error
>you are getting after executing the command.
>Thanks
>Hari
>MCDBA
>"Scott Sheen" <anonymous@.discussions.microsoft.com> wrote in message
>news:DA63BEEE-BF15-411E-89D1-654B42263897@.microsoft.com...
>above error. I am using MS SQL 2000
>
eason you see now. The
default database for the user you are logging in as doesn't exist (for some
reason), which mean that
you cannot login! Actually ISQL.EXE and I think OSQL.EXE will let you in, so
use any of these tools
to login and then use sp_defaultdb to change the default database. Or, login
as another login which
work and let that login change the default database for you (that login need
to be sysadmin).
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Scott Sheen" <sasheen@.oanet.com> wrote in message news:OCbFYSu6DHA.3008@.TK2MSFTNGP09.phx.gbl...[Q
UOTE]
> I can not login to query analyzer.
> Unable to connect to server ...
> Server: Msg 4064, Level 16 State 1
> Cannot open user default database. Login failed.
> This is similiar and related to the error I am getting in enterprise manag
er.
> A connection could not be established to ...
> Reason: Cannot open user default database. login failed..
> ...
> I was coping over a DB file and when I started up the manage I had this er
ror.
> I forgot the log file. I restored to my original version of that DB file.
I
> then detached that db and tried to reattach the new version of the db (fro
m a
> different PC) which failed and logged me out of the server. I figured tha
t was
> because that DB was my default DB.
> Thanks for your help.
> Scott
> "Hari" <hari_prasad_k@.hotmail.com> wrote:
>[/QUOTE]|||Scott
Try give permissions to the def database by using
sp_grantdbaccess [@.loginame =] 'login'
[,[@.name_in_db =] 'name_in_db' [OUTPUT]]
OR
Drop the login and by using sp_addlogin create a new one with default
database access.
For more details please refer to BOL
"Scott Sheen" <sasheen@.oanet.com> wrote in message
news:OCbFYSu6DHA.3008@.TK2MSFTNGP09.phx.gbl...
quote:
> I can not login to query analyzer.
> Unable to connect to server ...
> Server: Msg 4064, Level 16 State 1
> Cannot open user default database. Login failed.
> This is similiar and related to the error I am getting in enterprise
manager.
quote:
> A connection could not be established to ...
> Reason: Cannot open user default database. login failed..
> ...
> I was coping over a DB file and when I started up the manage I had this
error.
quote:
> I forgot the log file. I restored to my original version of that DB file.
I
quote:
> then detached that db and tried to reattach the new version of the db
(from a
quote:
> different PC) which failed and logged me out of the server. I figured
that was
quote:|||ok, none of these suggestions are working, as I can not log on to isql or os
> because that DB was my default DB.
> Thanks for your help.
> Scott
> "Hari" <hari_prasad_k@.hotmail.com> wrote:
the[QUOTE]
>
ql
either.
I can not seem to recreate a new server and DB either as I get the same erro
r.
Anymore suggestions?
Best Regards,
Scott S.
"Uri Dimant" <urid@.iscar.co.il> wrote:
quote:|||Some partial good news.
>Scott
>Try give permissions to the def database by using
>sp_grantdbaccess [@.loginame =] 'login'
> [,[@.name_in_db =] 'name_in_db' [OUTPUT]]
>OR
> Drop the login and by using sp_addlogin create a new one with default
>database access.
>For more details please refer to BOL
>
>"Scott Sheen" <sasheen@.oanet.com> wrote in message
>news:OCbFYSu6DHA.3008@.TK2MSFTNGP09.phx.gbl...
>manager.
>error.
>I
>(from a
>that was
>the
>
isql -E
will get me into iSQL. sp_defaultdb ' ...', 'master' will change the defa
ult
DB.
However, in my confusion late night I removed all the dbs under the server t
o
start over.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
quote:|||I fixed the problem. I started isql via isql -E. That logged me on. I the
>I do not recommend changing the default database for sysadmins of the very
>reason you see now. The
>default database for the user you are logging in as doesn't exist (for some
>reason), which mean that
>you cannot login! Actually ISQL.EXE and I think OSQL.EXE will let you in, s
o
>use any of these tools
>to login and then use sp_defaultdb to change the default database. Or, logi
n
>as another login which
>work and let that login change the default database for you (that login nee
d
>to be sysadmin).
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?oi=...ublic.sqlserver
>
>"Scott Sheen" <sasheen@.oanet.com> wrote in message
>news:OCbFYSu6DHA.3008@.TK2MSFTNGP09.phx.gbl...
>
n
created a new DB, made that the default and all was good.
Scott
quote:
>I deattached my default DB and crashed on reattaching it. I now get the ab
ove
>error. I am using MS SQL 2000
>Any suggestions or advice?
>Thanks
>Scott
Can not open user default database.
I deattached my default DB and crashed on reattaching it. I now get the above error. I am using MS SQL 200
Any suggestions or advice
Thank
ScottHi,
Can you please check whether the database is accessible.
1. Login as SA in query analyzer
2. execute the command
use dbname (replace database name with actual)
3. If you can open the database then no issues, otherwise send the error
you are getting after executing the command.
Thanks
Hari
MCDBA
"Scott Sheen" <anonymous@.discussions.microsoft.com> wrote in message
news:DA63BEEE-BF15-411E-89D1-654B42263897@.microsoft.com...
> I deattached my default DB and crashed on reattaching it. I now get the
above error. I am using MS SQL 2000
> Any suggestions or advice?
> Thanks
> Scott|||I can not login to query analyzer.
Unable to connect to server ...
Server: Msg 4064, Level 16 State 1
Cannot open user default database. Login failed.
This is similiar and related to the error I am getting in enterprise manager.
A connection could not be established to ...
Reason: Cannot open user default database. login failed..
...
I was coping over a DB file and when I started up the manage I had this error.
I forgot the log file. I restored to my original version of that DB file. I
then detached that db and tried to reattach the new version of the db (from a
different PC) which failed and logged me out of the server. I figured that was
because that DB was my default DB.
Thanks for your help.
Scott
"Hari" <hari_prasad_k@.hotmail.com> wrote:
>Hi,
>Can you please check whether the database is accessible.
>1. Login as SA in query analyzer
>2. execute the command
> use dbname (replace database name with actual)
>3. If you can open the database then no issues, otherwise send the error
>you are getting after executing the command.
>Thanks
>Hari
>MCDBA
>"Scott Sheen" <anonymous@.discussions.microsoft.com> wrote in message
>news:DA63BEEE-BF15-411E-89D1-654B42263897@.microsoft.com...
>> I deattached my default DB and crashed on reattaching it. I now get the
>above error. I am using MS SQL 2000
>> Any suggestions or advice?
>> Thanks
>> Scott
>|||I do not recommend changing the default database for sysadmins of the very reason you see now. The
default database for the user you are logging in as doesn't exist (for some reason), which mean that
you cannot login! Actually ISQL.EXE and I think OSQL.EXE will let you in, so use any of these tools
to login and then use sp_defaultdb to change the default database. Or, login as another login which
work and let that login change the default database for you (that login need to be sysadmin).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Scott Sheen" <sasheen@.oanet.com> wrote in message news:OCbFYSu6DHA.3008@.TK2MSFTNGP09.phx.gbl...
> I can not login to query analyzer.
> Unable to connect to server ...
> Server: Msg 4064, Level 16 State 1
> Cannot open user default database. Login failed.
> This is similiar and related to the error I am getting in enterprise manager.
> A connection could not be established to ...
> Reason: Cannot open user default database. login failed..
> ...
> I was coping over a DB file and when I started up the manage I had this error.
> I forgot the log file. I restored to my original version of that DB file. I
> then detached that db and tried to reattach the new version of the db (from a
> different PC) which failed and logged me out of the server. I figured that was
> because that DB was my default DB.
> Thanks for your help.
> Scott
> "Hari" <hari_prasad_k@.hotmail.com> wrote:
> >Hi,
> >
> >Can you please check whether the database is accessible.
> >
> >1. Login as SA in query analyzer
> >2. execute the command
> >
> > use dbname (replace database name with actual)
> >
> >3. If you can open the database then no issues, otherwise send the error
> >you are getting after executing the command.
> >
> >Thanks
> >Hari
> >MCDBA
> >
> >"Scott Sheen" <anonymous@.discussions.microsoft.com> wrote in message
> >news:DA63BEEE-BF15-411E-89D1-654B42263897@.microsoft.com...
> >> I deattached my default DB and crashed on reattaching it. I now get the
> >above error. I am using MS SQL 2000
> >>
> >> Any suggestions or advice?
> >> Thanks
> >> Scott
> >
> >
>|||Scott
Try give permissions to the def database by using
sp_grantdbaccess [@.loginame =] 'login'
[,[@.name_in_db =] 'name_in_db' [OUTPUT]]
OR
Drop the login and by using sp_addlogin create a new one with default
database access.
For more details please refer to BOL
"Scott Sheen" <sasheen@.oanet.com> wrote in message
news:OCbFYSu6DHA.3008@.TK2MSFTNGP09.phx.gbl...
> I can not login to query analyzer.
> Unable to connect to server ...
> Server: Msg 4064, Level 16 State 1
> Cannot open user default database. Login failed.
> This is similiar and related to the error I am getting in enterprise
manager.
> A connection could not be established to ...
> Reason: Cannot open user default database. login failed..
> ...
> I was coping over a DB file and when I started up the manage I had this
error.
> I forgot the log file. I restored to my original version of that DB file.
I
> then detached that db and tried to reattach the new version of the db
(from a
> different PC) which failed and logged me out of the server. I figured
that was
> because that DB was my default DB.
> Thanks for your help.
> Scott
> "Hari" <hari_prasad_k@.hotmail.com> wrote:
> >Hi,
> >
> >Can you please check whether the database is accessible.
> >
> >1. Login as SA in query analyzer
> >2. execute the command
> >
> > use dbname (replace database name with actual)
> >
> >3. If you can open the database then no issues, otherwise send the error
> >you are getting after executing the command.
> >
> >Thanks
> >Hari
> >MCDBA
> >
> >"Scott Sheen" <anonymous@.discussions.microsoft.com> wrote in message
> >news:DA63BEEE-BF15-411E-89D1-654B42263897@.microsoft.com...
> >> I deattached my default DB and crashed on reattaching it. I now get
the
> >above error. I am using MS SQL 2000
> >>
> >> Any suggestions or advice?
> >> Thanks
> >> Scott
> >
> >
>|||ok, none of these suggestions are working, as I can not log on to isql or osql
either.
I can not seem to recreate a new server and DB either as I get the same error.
Anymore suggestions?
Best Regards,
Scott S.
"Uri Dimant" <urid@.iscar.co.il> wrote:
>Scott
>Try give permissions to the def database by using
>sp_grantdbaccess [@.loginame =] 'login'
> [,[@.name_in_db =] 'name_in_db' [OUTPUT]]
>OR
> Drop the login and by using sp_addlogin create a new one with default
>database access.
>For more details please refer to BOL
>
>"Scott Sheen" <sasheen@.oanet.com> wrote in message
>news:OCbFYSu6DHA.3008@.TK2MSFTNGP09.phx.gbl...
>> I can not login to query analyzer.
>> Unable to connect to server ...
>> Server: Msg 4064, Level 16 State 1
>> Cannot open user default database. Login failed.
>> This is similiar and related to the error I am getting in enterprise
>manager.
>> A connection could not be established to ...
>> Reason: Cannot open user default database. login failed..
>> ...
>> I was coping over a DB file and when I started up the manage I had this
>error.
>> I forgot the log file. I restored to my original version of that DB file.
>I
>> then detached that db and tried to reattach the new version of the db
>(from a
>> different PC) which failed and logged me out of the server. I figured
>that was
>> because that DB was my default DB.
>> Thanks for your help.
>> Scott
>> "Hari" <hari_prasad_k@.hotmail.com> wrote:
>> >Hi,
>> >
>> >Can you please check whether the database is accessible.
>> >
>> >1. Login as SA in query analyzer
>> >2. execute the command
>> >
>> > use dbname (replace database name with actual)
>> >
>> >3. If you can open the database then no issues, otherwise send the error
>> >you are getting after executing the command.
>> >
>> >Thanks
>> >Hari
>> >MCDBA
>> >
>> >"Scott Sheen" <anonymous@.discussions.microsoft.com> wrote in message
>> >news:DA63BEEE-BF15-411E-89D1-654B42263897@.microsoft.com...
>> >> I deattached my default DB and crashed on reattaching it. I now get
>the
>> >above error. I am using MS SQL 2000
>> >>
>> >> Any suggestions or advice?
>> >> Thanks
>> >> Scott
>> >
>> >
>|||Some partial good news.
isql -E
will get me into iSQL. sp_defaultdb ' ...', 'master' will change the default
DB.
However, in my confusion late night I removed all the dbs under the server to
start over.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
>I do not recommend changing the default database for sysadmins of the very
>reason you see now. The
>default database for the user you are logging in as doesn't exist (for some
>reason), which mean that
>you cannot login! Actually ISQL.EXE and I think OSQL.EXE will let you in, so
>use any of these tools
>to login and then use sp_defaultdb to change the default database. Or, login
>as another login which
>work and let that login change the default database for you (that login need
>to be sysadmin).
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Scott Sheen" <sasheen@.oanet.com> wrote in message
>news:OCbFYSu6DHA.3008@.TK2MSFTNGP09.phx.gbl...
>> I can not login to query analyzer.
>> Unable to connect to server ...
>> Server: Msg 4064, Level 16 State 1
>> Cannot open user default database. Login failed.
>> This is similiar and related to the error I am getting in enterprise manager.
>> A connection could not be established to ...
>> Reason: Cannot open user default database. login failed..
>> ...
>> I was coping over a DB file and when I started up the manage I had this
>>error.
>> I forgot the log file. I restored to my original version of that DB file. I
>> then detached that db and tried to reattach the new version of the db (from a
>> different PC) which failed and logged me out of the server. I figured that
>>was
>> because that DB was my default DB.
>> Thanks for your help.
>> Scott
>> "Hari" <hari_prasad_k@.hotmail.com> wrote:
>> >Hi,
>> >
>> >Can you please check whether the database is accessible.
>> >
>> >1. Login as SA in query analyzer
>> >2. execute the command
>> >
>> > use dbname (replace database name with actual)
>> >
>> >3. If you can open the database then no issues, otherwise send the error
>> >you are getting after executing the command.
>> >
>> >Thanks
>> >Hari
>> >MCDBA
>> >
>> >"Scott Sheen" <anonymous@.discussions.microsoft.com> wrote in message
>> >news:DA63BEEE-BF15-411E-89D1-654B42263897@.microsoft.com...
>> >> I deattached my default DB and crashed on reattaching it. I now get the
>> >above error. I am using MS SQL 2000
>> >>
>> >> Any suggestions or advice?
>> >> Thanks
>> >> Scott
>> >
>> >
>|||I fixed the problem. I started isql via isql -E. That logged me on. I then
created a new DB, made that the default and all was good.
Scott
>I deattached my default DB and crashed on reattaching it. I now get the above
>error. I am using MS SQL 2000
>Any suggestions or advice?
>Thanks
>Scott
Any suggestions or advice
Thank
ScottHi,
Can you please check whether the database is accessible.
1. Login as SA in query analyzer
2. execute the command
use dbname (replace database name with actual)
3. If you can open the database then no issues, otherwise send the error
you are getting after executing the command.
Thanks
Hari
MCDBA
"Scott Sheen" <anonymous@.discussions.microsoft.com> wrote in message
news:DA63BEEE-BF15-411E-89D1-654B42263897@.microsoft.com...
> I deattached my default DB and crashed on reattaching it. I now get the
above error. I am using MS SQL 2000
> Any suggestions or advice?
> Thanks
> Scott|||I can not login to query analyzer.
Unable to connect to server ...
Server: Msg 4064, Level 16 State 1
Cannot open user default database. Login failed.
This is similiar and related to the error I am getting in enterprise manager.
A connection could not be established to ...
Reason: Cannot open user default database. login failed..
...
I was coping over a DB file and when I started up the manage I had this error.
I forgot the log file. I restored to my original version of that DB file. I
then detached that db and tried to reattach the new version of the db (from a
different PC) which failed and logged me out of the server. I figured that was
because that DB was my default DB.
Thanks for your help.
Scott
"Hari" <hari_prasad_k@.hotmail.com> wrote:
>Hi,
>Can you please check whether the database is accessible.
>1. Login as SA in query analyzer
>2. execute the command
> use dbname (replace database name with actual)
>3. If you can open the database then no issues, otherwise send the error
>you are getting after executing the command.
>Thanks
>Hari
>MCDBA
>"Scott Sheen" <anonymous@.discussions.microsoft.com> wrote in message
>news:DA63BEEE-BF15-411E-89D1-654B42263897@.microsoft.com...
>> I deattached my default DB and crashed on reattaching it. I now get the
>above error. I am using MS SQL 2000
>> Any suggestions or advice?
>> Thanks
>> Scott
>|||I do not recommend changing the default database for sysadmins of the very reason you see now. The
default database for the user you are logging in as doesn't exist (for some reason), which mean that
you cannot login! Actually ISQL.EXE and I think OSQL.EXE will let you in, so use any of these tools
to login and then use sp_defaultdb to change the default database. Or, login as another login which
work and let that login change the default database for you (that login need to be sysadmin).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Scott Sheen" <sasheen@.oanet.com> wrote in message news:OCbFYSu6DHA.3008@.TK2MSFTNGP09.phx.gbl...
> I can not login to query analyzer.
> Unable to connect to server ...
> Server: Msg 4064, Level 16 State 1
> Cannot open user default database. Login failed.
> This is similiar and related to the error I am getting in enterprise manager.
> A connection could not be established to ...
> Reason: Cannot open user default database. login failed..
> ...
> I was coping over a DB file and when I started up the manage I had this error.
> I forgot the log file. I restored to my original version of that DB file. I
> then detached that db and tried to reattach the new version of the db (from a
> different PC) which failed and logged me out of the server. I figured that was
> because that DB was my default DB.
> Thanks for your help.
> Scott
> "Hari" <hari_prasad_k@.hotmail.com> wrote:
> >Hi,
> >
> >Can you please check whether the database is accessible.
> >
> >1. Login as SA in query analyzer
> >2. execute the command
> >
> > use dbname (replace database name with actual)
> >
> >3. If you can open the database then no issues, otherwise send the error
> >you are getting after executing the command.
> >
> >Thanks
> >Hari
> >MCDBA
> >
> >"Scott Sheen" <anonymous@.discussions.microsoft.com> wrote in message
> >news:DA63BEEE-BF15-411E-89D1-654B42263897@.microsoft.com...
> >> I deattached my default DB and crashed on reattaching it. I now get the
> >above error. I am using MS SQL 2000
> >>
> >> Any suggestions or advice?
> >> Thanks
> >> Scott
> >
> >
>|||Scott
Try give permissions to the def database by using
sp_grantdbaccess [@.loginame =] 'login'
[,[@.name_in_db =] 'name_in_db' [OUTPUT]]
OR
Drop the login and by using sp_addlogin create a new one with default
database access.
For more details please refer to BOL
"Scott Sheen" <sasheen@.oanet.com> wrote in message
news:OCbFYSu6DHA.3008@.TK2MSFTNGP09.phx.gbl...
> I can not login to query analyzer.
> Unable to connect to server ...
> Server: Msg 4064, Level 16 State 1
> Cannot open user default database. Login failed.
> This is similiar and related to the error I am getting in enterprise
manager.
> A connection could not be established to ...
> Reason: Cannot open user default database. login failed..
> ...
> I was coping over a DB file and when I started up the manage I had this
error.
> I forgot the log file. I restored to my original version of that DB file.
I
> then detached that db and tried to reattach the new version of the db
(from a
> different PC) which failed and logged me out of the server. I figured
that was
> because that DB was my default DB.
> Thanks for your help.
> Scott
> "Hari" <hari_prasad_k@.hotmail.com> wrote:
> >Hi,
> >
> >Can you please check whether the database is accessible.
> >
> >1. Login as SA in query analyzer
> >2. execute the command
> >
> > use dbname (replace database name with actual)
> >
> >3. If you can open the database then no issues, otherwise send the error
> >you are getting after executing the command.
> >
> >Thanks
> >Hari
> >MCDBA
> >
> >"Scott Sheen" <anonymous@.discussions.microsoft.com> wrote in message
> >news:DA63BEEE-BF15-411E-89D1-654B42263897@.microsoft.com...
> >> I deattached my default DB and crashed on reattaching it. I now get
the
> >above error. I am using MS SQL 2000
> >>
> >> Any suggestions or advice?
> >> Thanks
> >> Scott
> >
> >
>|||ok, none of these suggestions are working, as I can not log on to isql or osql
either.
I can not seem to recreate a new server and DB either as I get the same error.
Anymore suggestions?
Best Regards,
Scott S.
"Uri Dimant" <urid@.iscar.co.il> wrote:
>Scott
>Try give permissions to the def database by using
>sp_grantdbaccess [@.loginame =] 'login'
> [,[@.name_in_db =] 'name_in_db' [OUTPUT]]
>OR
> Drop the login and by using sp_addlogin create a new one with default
>database access.
>For more details please refer to BOL
>
>"Scott Sheen" <sasheen@.oanet.com> wrote in message
>news:OCbFYSu6DHA.3008@.TK2MSFTNGP09.phx.gbl...
>> I can not login to query analyzer.
>> Unable to connect to server ...
>> Server: Msg 4064, Level 16 State 1
>> Cannot open user default database. Login failed.
>> This is similiar and related to the error I am getting in enterprise
>manager.
>> A connection could not be established to ...
>> Reason: Cannot open user default database. login failed..
>> ...
>> I was coping over a DB file and when I started up the manage I had this
>error.
>> I forgot the log file. I restored to my original version of that DB file.
>I
>> then detached that db and tried to reattach the new version of the db
>(from a
>> different PC) which failed and logged me out of the server. I figured
>that was
>> because that DB was my default DB.
>> Thanks for your help.
>> Scott
>> "Hari" <hari_prasad_k@.hotmail.com> wrote:
>> >Hi,
>> >
>> >Can you please check whether the database is accessible.
>> >
>> >1. Login as SA in query analyzer
>> >2. execute the command
>> >
>> > use dbname (replace database name with actual)
>> >
>> >3. If you can open the database then no issues, otherwise send the error
>> >you are getting after executing the command.
>> >
>> >Thanks
>> >Hari
>> >MCDBA
>> >
>> >"Scott Sheen" <anonymous@.discussions.microsoft.com> wrote in message
>> >news:DA63BEEE-BF15-411E-89D1-654B42263897@.microsoft.com...
>> >> I deattached my default DB and crashed on reattaching it. I now get
>the
>> >above error. I am using MS SQL 2000
>> >>
>> >> Any suggestions or advice?
>> >> Thanks
>> >> Scott
>> >
>> >
>|||Some partial good news.
isql -E
will get me into iSQL. sp_defaultdb ' ...', 'master' will change the default
DB.
However, in my confusion late night I removed all the dbs under the server to
start over.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
>I do not recommend changing the default database for sysadmins of the very
>reason you see now. The
>default database for the user you are logging in as doesn't exist (for some
>reason), which mean that
>you cannot login! Actually ISQL.EXE and I think OSQL.EXE will let you in, so
>use any of these tools
>to login and then use sp_defaultdb to change the default database. Or, login
>as another login which
>work and let that login change the default database for you (that login need
>to be sysadmin).
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Scott Sheen" <sasheen@.oanet.com> wrote in message
>news:OCbFYSu6DHA.3008@.TK2MSFTNGP09.phx.gbl...
>> I can not login to query analyzer.
>> Unable to connect to server ...
>> Server: Msg 4064, Level 16 State 1
>> Cannot open user default database. Login failed.
>> This is similiar and related to the error I am getting in enterprise manager.
>> A connection could not be established to ...
>> Reason: Cannot open user default database. login failed..
>> ...
>> I was coping over a DB file and when I started up the manage I had this
>>error.
>> I forgot the log file. I restored to my original version of that DB file. I
>> then detached that db and tried to reattach the new version of the db (from a
>> different PC) which failed and logged me out of the server. I figured that
>>was
>> because that DB was my default DB.
>> Thanks for your help.
>> Scott
>> "Hari" <hari_prasad_k@.hotmail.com> wrote:
>> >Hi,
>> >
>> >Can you please check whether the database is accessible.
>> >
>> >1. Login as SA in query analyzer
>> >2. execute the command
>> >
>> > use dbname (replace database name with actual)
>> >
>> >3. If you can open the database then no issues, otherwise send the error
>> >you are getting after executing the command.
>> >
>> >Thanks
>> >Hari
>> >MCDBA
>> >
>> >"Scott Sheen" <anonymous@.discussions.microsoft.com> wrote in message
>> >news:DA63BEEE-BF15-411E-89D1-654B42263897@.microsoft.com...
>> >> I deattached my default DB and crashed on reattaching it. I now get the
>> >above error. I am using MS SQL 2000
>> >>
>> >> Any suggestions or advice?
>> >> Thanks
>> >> Scott
>> >
>> >
>|||I fixed the problem. I started isql via isql -E. That logged me on. I then
created a new DB, made that the default and all was good.
Scott
>I deattached my default DB and crashed on reattaching it. I now get the above
>error. I am using MS SQL 2000
>Any suggestions or advice?
>Thanks
>Scott
Subscribe to:
Posts (Atom)