Open Desktop Edition Database in Enterprise Manager 1

[CassidyHunt]

Is there a way to view a desktop database version in enterprise manager? If not is there way to enable remote access to the desktop version?

Thanks

Cassidy

 

[gmmastros]

I assume you want to know if you can use Enterprise Manager to connect to an MSDE database?

If so, the answer is yes. I do this all the time.

In Enterprise Manager, drill down to 'SQL Server Group'
Right Click -> 'New SQL Server Registration'
Follow the wizard to connect to an instance of MSDE.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[CassidyHunt]

I tried that and it wouldn't allow me to do that. What I have is Autodesk Vault which runs a SQL Server Desktop edition for the database. I have a full version of SQL Server 2000 SP4 on the same machine but I can not get it to pull up that database. It tells me same name already exists and the database never pulls up in the database list.

Any other routes I can take? Maybe have to do something at the sql command prompt to the desktop version to allow the connection?

 

[gmmastros]

You need to know the instance name. Do this...

Click Start->Run
Type Services.msc
Click OK

Scroll down through the list of services until you see MSSQLSERVER.

There should be at least 2 of these for you. One is probably MSSQLSERVER and the other is probably MSSQL$(InstanceName).

When adding the server in the wizard, try specifying the ComputerName and the Instance name together, like this...

ComputerName\InstanceName

Then click the Add button.

On the next screen, where you select an Authentication Mode, pick Windows Account.

That should do the trick. Good Luck.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[CassidyHunt]

If I could give you two stars I would. Thank you

 

[gmmastros]

I think your problem was that the Autodesk vault instance was configured to 'hide server'.

In Enterprise Manager, Right click on the instance.
Click Properties.
On the General Tab, Click Network Configuration.
In Enabled Protocols, click TCP/IP
Click Properties...

You will see the TCP/IP port that the instance uses, but there is also a check box for 'Hide Server'.

Pretty clever of Microsoft to put that in there, huh?



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[CassidyHunt]

Yeah.. That makes life much more difficult if you want to import data. Now I have to figure out how to create an entity diagram so I can map data from my ERP to Vault so we only have to enter data once.