SQL Server Management Studio 2008 Express failed to retrieve data
  Home FAQ Contact Sign in
microsoft.public.sqlserver.tools only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... sqlserver.tools Profile…
 Up
SQL Server Management Studio 2008 Express failed to retrieve data         


Author: Alberto
Date: Sep 12, 2008 09:43

Failed to retrieve data for this request.
(Microsoft.SqlServer.Management.Sdk.Sfc)
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Server user 'name_user' is not a valid user in database 'winper_db'.
(Microsoft SQL Server, Error: 916)
3 Comments
Re: SQL Server Management Studio 2008 Express failed to retrieve data         


Author: Erland Sommarskog
Date: Sep 12, 2008 14:08

Alberto (Alberto@discussions.microsoft.com) writes:
> Failed to retrieve data for this request.
> (Microsoft.SqlServer.Management.Sdk.Sfc)
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> Server user 'name_user' is not a valid user in database 'winper_db'.
> (Microsoft SQL Server, Error: 916)

And the question is? The error message is fairly clear. Do you have reason
to expect to be able to access winper_db?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
no comments
Re: SQL Server Management Studio 2008 Express failed to retrieve d         


Author: Alberto
Date: Sep 12, 2008 15:50

Erlan, this error message is displayed only when i connet to sql server 2000
(version 8.0.760), why ?

"Erland Sommarskog" wrote:
> Alberto (Alberto@discussions.microsoft.com) writes:
>> Failed to retrieve data for this request.
>> (Microsoft.SqlServer.Management.Sdk.Sfc)
>> ADDITIONAL INFORMATION:
>> An exception occurred while...
Show full article (1.00Kb)
no comments
Re: SQL Server Management Studio 2008 Express failed to retrieve d         


Author: Tibor Karaszi
Date: Sep 13, 2008 00:58

It seems that the login you use has a default database winper_db, but the login doesn't exist as a
user in that database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"Alberto" discussions.microsoft.com> wrote in message
news:86FCD8BF-3284-4CEE-91DC-AF3D5A9C85D2@microsoft.com...
> Erlan, this error message is displayed only when i connet to sql server 2000...
Show full article (1.39Kb)
no comments

RELATED THREADS
SubjectArticles qty Group
SQL Profiler in SQL Server 20002 microsoft.public.sqlserver.programming ·