question

j_jakkals avatar image
j_jakkals asked

my sql host changed from workgroup t dc, ole 800 error now, please help

I support an app, connecting to sql server. The server used to be set up as being in a workgroup. Today, due to new microsoft rdp requirements, IT changed the machine to a domain controller. I get an ole 800 error when opening my app (after attaching the mdf files), and i cannot expand any tables.Is it a permission / access issue, the mdf and ldf files cannot be broken? Thank ou
sql server
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
It sounds like a security issue. The SQL Server service has to run under an account. And you have to log in to the server on an account. Check the Configuration Manager to see how your server is set up and what account it's using. You'll need a domain account for the server and you can modify it there.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.