Monday, March 12, 2012

MSDE - MSSQL$MICROSOFTSMLBIZ ?

I need to work with MSDE on a new laptop ive been given. Apparently msde is already installed. I have a service runningnamed "MSSQL$MICROSOFTSMLBIZ" - how do i configure it, or shouldI just download a later copy of msde and setup a new copy ? Iknow I know...use sql express. However, I need to work with msdein this case to make it easier (on me) for moving the data into a sql2000 database.

thanks

So you have SQL2000 instance? Then you can register the MSDE instance in Enterprise Manager, thus it should be much easier to manage the MSDE databases: Open Enterprise Manager->right click a SQL Server Group->choose New SQL Server Registration.

Otherwise you have to use osql utility to manage MSDE, which would be painful if you're not familiar with T-SQL.

No comments:

Post a Comment