SQL Enterprise manager

[D Panchal]

Dear all,

Can’t seem to login to SQL with SQL Enterprise manager (can access SQL with ISQL) getting error message below any idea’s

Error message ‘A connection could not be establish to TRACY –[SQL Server] Violation of PRIMARY KEY constraint ‘PK_#SQLOLEDbU_dbid_5A7552C1’: Attempt to insert duplicate key in object
#SQLOLEDdUserProfile0000000077f’.


Any help would be greatly appreciated!

Thank you!

------------
D Panchal at 3/11/99 8:16:53 AM


Dear all,

Can’t seem to login to SQL with SQL Enterprise manager (can access SQL with ISQL) getting error message below any idea’s

Error message ‘A connection could not be establish to TRACY –[SQL Server] Violation of PRIMARY KEY constraint ‘PK_#SQLOLEDbU_dbid_5A7552C1’: Attempt to insert duplicate key in object
#SQLOLEDdUserProfile0000000077f’.


Any help would be greatly appreciated!

Thank you!


The problem maybe (not sure) that you have accidentally inserted duplicate records due to some modificatiuons you are making to the table structures.

Just try to check if possible the latest updates done to your tables if possible and remove the duplicate data if you find some


Adois

[Gregory]

it seems like, problem is in tempdb (that object is in tempdb - if you do 'select name from tempdb..sysobjects' - you'll see '#SQLOLEDdUserProfile0000000077f' which is a user-defined table) - so I'd say you may need simply restart SQL Server to clear tempdb.....?

------------
at 3/11/99 9:58:56 AM




------------
D Panchal at 3/11/99 8:16:53 AM


Dear all,

Can’t seem to login to SQL with SQL Enterprise manager (can access SQL with ISQL) getting error message below any idea’s

Error message ‘A connection could not be establish to TRACY –[SQL Server] Violation of PRIMARY KEY constraint ‘PK_#SQLOLEDbU_dbid_5A7552C1’: Attempt to insert duplicate key in object
#SQLOLEDdUserProfile0000000077f’.


Any help would be greatly appreciated!

Thank you!


The problem maybe (not sure) that you have accidentally inserted duplicate records due to some modificatiuons you are making to the table structures.

Just try to check if possible the latest updates done to your tables if possible and remove the duplicate data if you find some


Adois

[Gregory]

you may also try to run dbcc checkdb(tempdb) from iSQL window....


------------
D Panchal at 3/11/99 8:16:53 AM


Dear all,

Can’t seem to login to SQL with SQL Enterprise manager (can access SQL with ISQL) getting error message below any idea’s

Error message ‘A connection could not be establish to TRACY –[SQL Server] Violation of PRIMARY KEY constraint ‘PK_#SQLOLEDbU_dbid_5A7552C1’: Attempt to insert duplicate key in object
#SQLOLEDdUserProfile0000000077f’.


Any help would be greatly appreciated!

Thank you!