Cannot Create Diagrams In Upgraded SQL Server 2000 Database
Dear all,
I am trying to save a newly created diagram in SQL Server 2005 SP1.
The error message is:
----Beginning of pasted error message---
===================================
Cannot insert the value NULL into column 'diagram_id', table 'adt_db.dbo.sysdiagrams'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The 'sp_creatediagram' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. (.Net SqlClient Data Provider)
------------------------------
Program Location:
at Microsoft.VisualStudio.DataTools.Interop.IDTDocTool.Save(Object dsRef, String path, Boolean okToOverwrite)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.DatabaseDesignerNode.Save(VSSAVEFLAGS dwSave, String strSilentSaveAsName, IVsUIShell pIVsUIShell, IntPtr punkDocDataIntPtr, String& strMkDocumentNew, Int32& pfCanceled)
----End of pasted error message---
The database I use has been upgraded from SQL Server 2000.
I am running in SQL Server 2000 Compatibility Mode (80) but changing the compatibility mode to SQL Server 2050 (90) does not make any difference with regards to this error.
View Complete Forum Thread with Replies
Related Forum Messages:
How To Create Database Diagrams In SQL Server Management Studio?
Hi: I installed SQL Server 2005 onto Vista RTM. When launched SQL Server Mangement Studio -> Databases -> choose a database and expand. Right click on top of "Database Diagrams" node, only options I've got are: 1. Working with SQL Server 2000 Diagram 2. Refresh. Wondering did I missing something on my system in order to make database diagrams to work? Thanks Tommy
View Replies !
Problem With Showing Diagrams When Attaching A Sql Server 2000 Database In Sql Server 2005
I have a database created in MS SQL Server 2000 with some tables and diagrams.I have attached that database in SQL Server 2005 but when i want to access and showthe diagrams i face the following error message :Database diagram support object can not be installed because this database does not havevalid owner,to continue first use the files page of database dialog box or alter the authorizationstatement to set the database owner to valid login then add the database diagram support object.I have created a role with required permissions but i still have the problem(I still can't show the diagrams withthe new user(role) )Has anyone faced this problem too?Can anyone help ?
View Replies !
Can't Create Database Diagrams
Hello, I'm using C# express with SQL express. I can create a database, create tables and I can even delete the database but I cannot create database digrams. I get an error that says I don't have a valid dbo user or permissions to impersonate. It asks me if I would like to impersonate but it just fails. Any Ideas? Thanks
View Replies !
Want To Be Able To Create Or View Database Diagrams
Our MS SQL (SQL Server 2000) DBA has database privileges locked downpretty tightly. We end users/developers do not have administratorprivileges for most databases. That arrangement has worked out OK forthe most part. However, it's a bit aggravating that we can't evencreate our own database diagrams. When we attempt to do so (inEnterprise Manager), we get a dialog that says "You do not havesufficient privilege to create a new database diagram."Our DBA is so busy that it's difficult to get them to create ones forus. And even when they do, it seems that we can't even view it online-- we rely on the DBA to give us printed copies or screenshots for ourdocumentation. How ridiculous is that? We'd also like to be able tomanipulate the diagrams online so that we can more easily study ourtable structures, indexes, foreign key constraints, etc. In fact,there doesn't even seem to be any other way to easily view currentforeign key constraints.I realize that this might have to do with the diagramming tool havingthe ability to actually manipulate the database in ways we aren'tsupposed to do (e.g., like creating new tables). However, isn't therea "read-only" version of this tool that will give us what I'm lookingfor? Short of that, are there any other free or cheap tools that willprovide this? Thanks!(Please forgive my ignorance if this has been hashed out before.However, I did search news groups and the web before posting, figuringthis had been covered before, but I didn't find anything thatspecifically addressed this issue.)
View Replies !
Server Error In '/' Application. Database Cannot Be Upgraded Because It Is Read Only??
Server Error in '/' Application. Database 'C:INETPUBDEMO.TRUTHSTONE.COMAPP_DATAASPNETDB.MDF' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITYNETWORK SERVICE'. Hi, Strange one. I have copied my working web-site to the production server and get this message. Tried copying new set of database files and reset the server to ensure no applications could be accessing the database files. Still get the same error. Works fine on my Visual Studio VWD Express version. Mitch PS I am not trying to upgrade the database, just use it!
View Replies !
SQL Server 2000 Diagrams Without Enterprise Manager
Hi,I currently (for a hobby project) am unable to use SQL Server 2005, and rather am stuck with 2000. Since the way diagrams are handled changed, the tool for 2005 doesn't allow for the creation of diagrams when using it for 2000 (work sweet for everything else though!).I do not have access to a developer version of SQL Server 2000's tools, and thus no Enterprise Manager, leading me to my question: Are there any free utilities to replace this functionality? I don't have MS Access or Visio or anything like that unfortunately :(
View Replies !
Upgraded From Sql 2000 To 2005
Hi all We recently upgraded from sql 2000 to sql server 2005. Our system was developed using Microsoft visual Basic. Since we upgraded to sql server 2005 our system has been very slow. I suspect that it was because of the new sql 2005 installation that i made. Does anyone know how to solve this problem for me to be able to increase the perfomance speeed of our system again. It has been stressing me for a while now. Pliz help Thanks!
View Replies !
SQL Server 2005 Database Diagrams
This question has been asked several times on this forum, but none of the answers I've seen have worked for me. I just upgraded from SQL Server 2000. The error I'm getting is: does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. This is a new database I created in SQL Server management studio. It's set to 90 compatibility level. I've tried the "alter authorization" command, which works, but it has no effect (the error is still returned). The odd part is that if I go to Server Properties->Permissions, select the Login that owns this database, and click "Effective Permissions", I get the error: Could not obtain information about Windows NT group/user '<username>', error code 0x6e. (Microsoft SQL Server, Error: 15404) But I know for certain that this account is valid and that my machine can reach the domain controller: 1) I received no error when I added this Login to the server and 2) I'm logged into SQL Server Management Studio using the same login. If I switch to the "sa" user, it works. But I'd really rather find out what I can't use Windows authentication.
View Replies !
Not Able To Create New Diagrams
I get a message that says the SQL Server is unable to create a new database diagram that I am saving. The error message says that the operation tried to insert a Null value into the version field of the dtproperties table. I get this message from both Enterprise Manager or from the VS.NET IDE. I would appreciate any information that indicates what is causing this error (I don't think I have had it before), and what I can do to fix it. Thanks for your attention. Al Corwin
View Replies !
Unable To Create Diagrams
Hi, My dba has setup permission such that I can do everything except I am unable to create diagrams in the database. It say I don't have enough permission to do that. Can somebody tell why I am unable to do that? thanks Rozina
View Replies !
Retrieving The Tables Relationship From SQL Server Database Diagrams
Hi All, Currently i am defining a simple relationship between Customers->Orders->Order Details through the Database Diagrams feature in the SQL 2K. Using the Server Explorer, i can see the Database Diagrams, but when i try to "drop" the Database Diagrams into the page, it gives the error message. I would like to know the procedures to retrieve the database relationships from Database Diagrams and manipulate them through ADO.NET I prefer to "convert" already defined relationship using SQL Server Database Diagrams into XSD file or probably there is another method to "read" those relationship and manipulate them. Thank you very much for all your help
View Replies !
Mirror Disconnected - Database Upgraded
Hi While a database upgrade schema changes were being made the Mirror became disconnected will this recover itself when it reconnects or will it be the case that we will have to copy the db files to the Mirror and set it up from scratch. It was set up as a synchronise mirror
View Replies !
Sql 2005 Sql 2000 DB Diagrams, Re-install Sql 2000, Need Help.....
Most of our sql servers ar still sql 2000. Our programmers created many sql 2000 database diagrams using EM. But they can not access them under sql 2005. (They now have only sql 2005 tools installed on their boxes.) Question: can we reinstall the sql 2000 client tools on their boxes without affecting the current sql 2005 install on their boxes? Question: is there any workaround negating the need to ihstall the sql 2000 client? TIA, barkingdog
View Replies !
Upgraded Express To Developer Edition Is Not As Easy As Advertised; Error When Adding A Database To Website
In trying to upgrade my sql express install from express to developer edition, I ended up having to delete all things express from my computer and do a clean install of developer edition (as i installed developer edition initially over sql express but this didnt seem to work; express edition still appeared in add remove programs etc). Anyway so i blew away the install and have a clean install of developer edition. Now when I create a new website in Visual Studio 2005 and try to add a database to the project, it gives me an error stating that i need to have sql server express 2005 installed to function properly... Do i need to have express AND developer edition of sql installed to do this? I would think developer edition of sql would enable me this functionality...http://img277.imageshack.us/img277/4228/sqlerrorie2.jpgThanks!It is also worth noting that I get the dreaded remote connection error when trying to connect to a db that I used to be able to connect to when I was using sql express (the aspnetdb database that is created when you user their membership stuff)"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) "However, I did the following successfully:1. create a database using the sql management studio2. added a table and some data to it3. threw a dataset into the website4. added a gridview to a page in the website, pulling data from the dataset5. and the website runs successfully populating the page with data...fyi: My sql services: http://img158.imageshack.us/img158/2020/sqlserviceshj6.jpg
View Replies !
Database Diagrams
Do you need to be a member of the dbo role or an sa on a particular sql server to create a database diagram? I just want to confirm this is the case. Any assistance will be helpful. Maria
View Replies !
Database Diagrams
Is there a way to use an Oracle linked server to create a database diagram? Or do I have to bring the whole Oracle db into SQL7 and then create the diagram? Peter Cwik
View Replies !
Please Help - Database Diagrams
Hi, I have a few users who are in the role 'public' that need to create database diagrams. For some reason, when they try to create one, it gives them the error 'YOU DO NOT HAVE SUFFICENT PERMISSIONS TO CREATE A NEW DATABASE DIAGRAM' I have checked in books online and it says that they are stored in dtproperties table. And you cannot set permissions on database diagrams. Can anyone help please? Thanks, Tag
View Replies !
Database Diagrams
Hello all, I upsized an access backend to sql 2005. In the process, the relationships were lost. When I go to the database in Sql, right click on database diagrams, all I get is refresh and a link to go to learn about database diagrams. How can I recreate the diagrams? Thanks
View Replies !
Database Diagrams !!!!
I am trying to follow this walkthrough<br><br>http://msdn2.microsoft.com/en-us/library/ms233763(VS.80).aspx<br>And getting nowhere as it says I need to set up database diagrams which I cannot due to not being in db_owner role, or not being valid db user etc etc.I cannot find out how to set this up for the database I created so far in t his tutorial.I have searched and searched and got nowhere.I then went into SSMSE by chance and found a load of roles but none named db_owner. I then tried to add my database file but SSMSE wont let me drill down into the required folderI weep!!!!Please can anyone help?
View Replies !
Database Diagrams
Hi All I am using SQL server 2000 and I would like to create Database diagrams but It doesn't give me any option to crate one. It only shows "Working with SQL Server 2000 diagrams" and "Refresh" with no "create new diagram" and in other servers it but its only in my desktop that doesn't and I have full access
View Replies !
DataBase Diagrams
In our organization, we are using SQL Server 2005 Management studio as the client interface to access all our enterprise Databases.Most of the databases are built on SQL 2005 DB Server. However, We have one of the Database built on SQL Server 2000, which also has Database diagrams in it. Though We are able to view all the DB objects through SQL 2005 managment studio interface, but unable to view the diagrams. I understand that, the binary data of the diagrams are stored in "dtproperties" table on SQL 2000 but in SQL 2005, it is stored in "sysobjects"(not sure) table and both are entirely different. Following are my questions. 1.Since the DB is still on SQL 2000,How can we view the diagram objects thru the SQL 2005 Enterprise manager. 2.For the migration process of SQL 2000 to SQL 2005, How can i migrate the database diagrams. Appreciate the responses.
View Replies !
How Do I Create A SQL 2005 Database From A SQL 2000
I have a SQL 2000 database on one server that I'm trying to transfer to a new server. The new server has Small Business Server R2 Premium Edition, which includes SQL 2005. I tried to transfer the database in the normal way that I'd create a copy database, which was: -1. Backup the source database2. Create a new database (empty) in the new server3. Restore to this database from the backup taken in #1. Of course on previous occasions I wasn't changing version, but I expected that this would either fail immediately (message "incorrect version" or some such), or else work. At first this appeared to transfer OK. It took about 20 minutes to create the backup (just over 5GB), and about the same time to restore it. The restore terminated with a message "Database has been restored successfully"). However, the database's icon in Management Studio's Object explorer showed a little up arrow, and alongside the database name "(restoring ....)". Clicking on the database icon did not expand it. 3 hours later it still was like this. Examining the server showed zero activity. I expect that it's failed, and I should delete the new "(restoring...)" database and start again. How should I create this SQL 2005 database?
View Replies !
Installing SSRS2005 On Upgraded Windows Server
I just finished installing the SQL Server 2005 Express Edition on a server that had been upgraded from Windows 2000 Server to Server '03. By default, an upgrade from Win2K Server will have IIS6 running in IIS5 compatibility mode. SSRS in this case will be installed to use the ASPNET account instead of the Network Service account, and it will fail to work. The error message is "Report Server Web Service is unable to access secure information..." I did some searching and found out how to switch IIS6 to its normal mode using the IIS Config Mgr. This allowed SSRS to get further, but it could not connect to the report database (and the corresponding temp db) because its Setup had not configured the Network Service account for access to these dbs. I used the SQL Mgr to add the login for the Network Service account and then added that login to the RSExec role in each of the SSRS dbs. So far, Reporting Services seems to be working properly now. I hope this post is of help to anyone else who encounters a similar situation.
View Replies !
Timeout Connecting To Upgraded 2005 Server
I just did a 2005 "In-Place" upgrade to a 2000 server yesterday, and now we're getting intermittant time-out errors trying to connect via SQL Server Management Studio. Sometimes we connect instantly, then if I try again 10 minutes later, it might time-out. No problems with our other 4 SQL 2005 servers (2 were just upgraded, 2 are native 2005). No timeouts so far when logged on to the server directly, just when logging in from our desks. It's set to TCPIP only (removed named pipes), but can't think what else might be the problem. Any ideas ? One little thing I just noticed while comparing to another server: In the console, a "good" server has the little green arrow on the server & SQL Agent icons, while the "problem" server is connected, but there is no green arrow. If I log on the server directly and open SQL, I get the green arrows. Is that trying to tell me something about the connection ??
View Replies !
Protecting EM Database Diagrams
Hidoes anyone know of a way of giving developers read only access to adatabase diagram in Enterprise Manager (SQL Server 2000). The database wassupplied by a third party and we don't want them tinkering with it, butthey do need to be able to create additional tables etc. to extend thefunctionality of the package.TIAChloe Crowder
View Replies !
Database Diagrams Problem....
Hi all, I am trying to make DATABASE DIAGRAMs....I have restored a database called Tel from a backup file...n in that i have all the tables and procedures..now whenever i m clicking on its DATABASE DIAGRAMS it gives me the error as: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. ------------------------------ so,what should i do??any suggestion will be helpful for me...thnks in advance... regards..
View Replies !
Navigate The Database Diagrams
I hope you´d like an opensource I've made called Nautilus. With a web browser you can navigate data and structure. Instead of building diagrams with Enterprise Manager you can make automatic diagrams around a table and then jump to one neighbor table. You can do the same once you locate a record and jump to related records. Nautilus (sqlserver) v1.0.3 Navigate your SQLServer 2000 database http://sourceforge.net/projects/nautilus/ Author: Marcos L. Casamayor WHAT ---- Nautilus is a tool for developers, advanced users and auditors. The main objetive is to navigate information and structure in a SQLServer database.
View Replies !
Database Diagrams - Take Too Long?
I am using Beta 3 and the database diagrams take over an hour to generate for approx 10 tables. The database has been transformed from SQL 6.5. Even opening a saved diagram takes quite long. Is this a feature of the beta or something else? Thanks. Jay Virdee
View Replies !
SQL Database Diagrams Online?
Hi, I hope i'm in the right forum. Is there a way to create a DB diagram schema via ASP/HTML and publish it on-line - keeping it up-to-date? I want to at least output a diagram schema to HTML format? Any ideas. TIA!
View Replies !
Database Diagrams Missing
Hi All, I€™ve just installed SQL 2008 Express CTP. Everything seems to be fine except that the folder €œDatabase Diagrams€? is absent in the tree of SQL Server Management Studio. It is the same for newly created databases and databases upgraded from 2005 Express. Any ideas how to get the diagrams back?
View Replies !
Database Diagrams Tool
When I use the sql 2005 "Database Diagrams" tool for the first time I always get the message: "The Database does not have one or more of the support objects required to use database diagramming. Do you wish to create them?" 1. Does anyone know what the " support objects" referred to are? 2. Why SQL doesn't automatically create these support objects for me? (e.g. do they require a lot of hard disk space so they shouldn't routinely be created?) 3. Is there any way to make Sql automatically create them? If you can address any of these points I'd appreciate it. TIA, barkingdog
View Replies !
Error In Database Diagrams
When I try to Create a Database Diagram it sends me an Error message like this: Server Name: TICSQLEXPRESS Error Number: 207 Severity: 16 State: 1 Procedure: sp_upgraddiagrams Line Number: 55 Invalid column name 'uvalue'. Invalid column name 'uvalue'. Could not find stored procedure 'dbo.sp_upgraddiagrams'. Object is invalid. Extended properties are not permitted on 'dbo.sysdiagrams', or the object does not exist. Object is invalid. Extended properties are not permitted on 'dbo.sp_upgraddiagrams', or the object does not exist. (.Net SqlClient Data Provider) How can I find that Stored Procedure 'dbo.sp_upgraddiagrams'? Why doesn't it work OK? Thank you!
View Replies !
How To Copy Database Diagrams?
Hi, I remember I asked the similar question before.But I have not solve this. I am working with SQL Server 2005. I just make a copy of the production database. I use "tasks -> Generate Script" to copy the table structure and use "tasks -> import Data" to copy Data. But I can not copy the database diagrams,I need to keep the primary keys - foreign keys relations. Please let me know how to copy database diagrams.I try many ways but I can not figure it out. Thanks for your help Mark
View Replies !
AdventureWorks Database - Cannot Access Database Diagrams
Hi, When I try to access the database diagrams in AdventureWorks, I get the following message: TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. ------------------------------ BUTTONS: OK ------------------------------ Why is this? All advice / help apprecuated. Thanks
View Replies !
Having Trouble Creating Database Diagrams
tried to add a third and fourth table to an exsiting relationship diagram in VS05 server explorer, when i click save i get an error "the operation could not be completed" i am able to create new diagrams but it seems every time i click save, and close the diagram the reopen it and add new tables then click save i get the same error message, i dont even try and create the actual relationship but just add a third table and boom the problem occurs thanks in advance
View Replies !
|
TRACKER
