When I tried to access the SQL 2005 Server here I got error

Being a typical DiscountASP.Net customer, I like trying new technologies, so I installed SQL server 2008 Standard Edition (RC 1 -180 day trial). I was able to access databases on my own machine, but when I tried to access the SQL 2005 Server here, I got error:
//////////////////////////////////////////

TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The server principal "SQL2005_504266_mockler_user" is not able to access the database "SQL2005_468370_evention1" under the current security context. (Microsoft SQL Server, Error: 916)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3215&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
///////////////////////////////////////

I had a similar error trying to access another remote database on another ISP. I am able to log in without error, but when expanding the database node, I get that error.

I still have the 2005 management studio working, so I can access from there, but just out of curiosity, does anyone have any idea on what needs to be done (on my end)?

Yes, It's BETA, I know!

Paolo

 

Hi Paolo,
Just thought of something...


Modify your shortcut for SQL Server Management Studio to run as Admin.
Properties, Compatibility tab, Privilege Level: Run this program as administrator.


That should take care of it.


Same is true in VS2008 on Vista, even for Templates.
Salute,
Mark

 

I just double checked and don't get any errors connecting to SQL Server 2005 here from my Vista SQL 2008.
My local version is:

Microsoft SQL Server Management Studio10.0.1300.13 ((SQL_PreRelease).080207-2350 )
Microsoft Analysis Services Client Tools2007.0100.1300.013 ((SQL_PreRelease).080207-2350 )
Microsoft Data Access Components (MDAC)6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML3.0 4.0 5.0 6.0
Microsoft Internet Explorer8.0.6001.17184
Microsoft .NET Framework2.0.50727.3031
Operating System6.0.6001