Connecting to the Microsoft SQL Server 2008 beta database using SQL SSMS 2008

Exciting. (Woot)

Installing the download x86 executable version on Vista SP1 right now.
Will definitely keep everyone posted.
Salute,
Mark Wisecarver aka wisemx

 

Beautiful. Worked like a charm.


Thanks,

 

I would love to be able to connect to the new beta instance, but I guess I don't have the proper rights on the server.

When I try to expand the list of databases, I get this:

The SELECT permission was denied on the object 'backupset', database 'msdb', schema 'dbo'. (Microsoft SQL Server, Error: 229)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1442&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476

Anybody have any suggestions?

I'm running the RC0 SSMS client with VS2008 installed on my Vista SP1 PC (32bit)

 

One more anomaly. I can't right click and view the Properties of the database. I get a casting error in the client. I suspect it has to do with permissions again as I can use the SQL2K8 client and view database properties on my local 08 instance.

I'd gladly work more closely with DASP support to iron out these little issues.

Thanks

 

That's odd...I was able to pull up properites just now even on System tables.
Salute,
Mark

 

I can do that as well. What I am trying to do is view the properties of the database. (I get the same error as I posted before if I right click on the master database and choose properties from the menu presented.)


The reason I am trying to get to the properties is that I wanted to know what the database defaults were set at, Recovery model, Auto shrink etc.


I also wanted to check out the new change tracking feature of 08.

 

Right'o...I just checked and can view the properties of my test DB but not the Master DB.
While I could view the properties of my DB I couldn't change it to Auto Shrink...permissions failed.
Salute,
Mark