SQL Server Management Studio

Database diagrams on disconnected devices

If you try to use the database diagram feature in SQL Server Management Studio and the owner of the database is a domain id but you are disconnected from the domain (notebook users!), you’ll get an error like this: “Database diagram support objects cannot be installed because this database does not have a valid owner. [...]

Categories: SQL Server Management Studio

Import using Excel in SSMS fails with “EXCEL” connection manager not recoginized.

Error: The connection type "EXCEL" specified for connection manager … is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.   I found one suggestion of reinstalling MDAC (right clicking %windir%\inf\mdac.inf->Install). Needed XP [...]

Categories: SQL Server Management Studio

Proudly powered by WordPress Theme: Adventure Journal by Contexture International.