Cannot create db diagram

When trying to create a DB diagram on my local SQL Server 2005 db, I get the following error:

cannot insert the value null into column "diagram_id"

I have searched the web and can't seem to find anything on this.

I just simply drag one table from my local db onto the diagram windows and try to Save it and that's what I get. I'm able to save diagrams on a networked SQL Server.

Does anybody know how I can resolve this issue?

Dear Bill

I am a newbie and have also experienced the same problem, on a local machine with SQL Server 2005 DE.

I have placed a similar msg on a few forums and no response to them as yet.

"MS SQL SERVER 2005 BUG? Cannot insert NULL into column diagram_id

Hi friends,

when trying to save a diagram I got an error:
The sp_creatediagram procedure attempted to return a status of NULL, which is not allowed."

Whats with this?

As far as I can work out, it has only started happening since I mucked around with the database properties such as ANSI NULLS true/false. I have put them back to default as a test and it doesnt fix the problem.

Have you got any ideas about it yet?

|||

This comes from the fact that the db was a prior version of sql server (via a conversion to 2005). This will not work.

You have to create the db brand new in sql server 2005, then import data from your sql server 2000 db, etc.

|||1. start>programs>microsoft visual studio 2005
2. file>new project>other project types>database>datbase project
3. connect to your database
4. solution explorer>database reference
5. server explorer>diagram
6. prompt: does not support diagram create?
7. click yes|||Bill - is this thread closed or do you still need help? If this is closed out you can mark it as "answered". Thanks!|||sounds good, but i had the same problem and this didn't work for me.|||

I have the same problem - is there any work around, or fix available?

I have tried to create the diagram from SQL Server Management Studio and Visual Studio 2005.

|||Are you trying to do this against SQL Server 2000 from 2005 or the other way around? Is the database set to a compatibility mode less than 9.0?|||

I have the same issue, and I have NEVER had SQL Server 2000 on any server here.

I am only getting this error on one or two of the 7 databases that I have on the SQL server instance.

--

Is there a way to delete the diagramming "stuff" so that when the create... option is chosen in Database Diagrams, it resets all of the sp's, etc.?

|||I'm not familiar with a way to do that. That isn't to say that there isn't one, so we'll leave this post open...Maybe someone will chime in!|||

Hi,

I had this problem as well (SQL 2005) - I simply deleted the sysdiagrams table from System Tables and created a new diagram allowing it to automatically create the database objects. This seemed to solve the problem.

Nick

|||

Hello:

This is what I did....

1. Created a Create Query for the System Tables > dbo.sysdiagrams

2. Changed the following statement:

[diagram_id] [int] DEFAULT ((0)),

3. Deleted the table: System Tables > dbo.sysdiagrams

4. Executed the modified query

5. Saved my diagram. It worked fine

6. I was even able to create and open multiple diagrams without any problems!

software786

|||Yes, this works. Ah, why isn't this fixed in SQL Server's updates?

Cannot create db diagram

When trying to create a DB diagram on my local SQL Server 2005 db, I get the following error:

cannot insert the value null into column "diagram_id"

I have searched the web and can't seem to find anything on this.

I just simply drag one table from my local db onto the diagram windows and try to Save it and that's what I get. I'm able to save diagrams on a networked SQL Server.

Does anybody know how I can resolve this issue?

Did you encounter the same issue in all of the databases in the local SQL server? Or just particular database(s)? I guess the issue is caused by a database attached from previous SQL server (2000 or 7.0), if it does, please let me know.

Cannot create db diagram

When trying to create a DB diagram on my local SQL Server 2005 db, I get the following error:

cannot insert the value null into column "diagram_id"

I have searched the web and can't seem to find anything on this.

I just simply drag one table from my local db onto the diagram windows and try to Save it and that's what I get. I'm able to save diagrams on a networked SQL Server.

Does anybody know how I can resolve this issue?

Dear Bill

I am a newbie and have also experienced the same problem, on a local machine with SQL Server 2005 DE.

I have placed a similar msg on a few forums and no response to them as yet.

"MS SQL SERVER 2005 BUG? Cannot insert NULL into column diagram_id

Hi friends,

when trying to save a diagram I got an error:
The sp_creatediagram procedure attempted to return a status of NULL, which is not allowed."

Whats with this?

As far as I can work out, it has only started happening since I mucked around with the database properties such as ANSI NULLS true/false. I have put them back to default as a test and it doesnt fix the problem.

Have you got any ideas about it yet?

|||

This comes from the fact that the db was a prior version of sql server (via a conversion to 2005). This will not work.

You have to create the db brand new in sql server 2005, then import data from your sql server 2000 db, etc.

|||1. start>programs>microsoft visual studio 2005
2. file>new project>other project types>database>datbase project
3. connect to your database
4. solution explorer>database reference
5. server explorer>diagram
6. prompt: does not support diagram create?
7. click yes|||Bill - is this thread closed or do you still need help? If this is closed out you can mark it as "answered". Thanks!|||sounds good, but i had the same problem and this didn't work for me.|||

I have the same problem - is there any work around, or fix available?

I have tried to create the diagram from SQL Server Management Studio and Visual Studio 2005.

|||Are you trying to do this against SQL Server 2000 from 2005 or the other way around? Is the database set to a compatibility mode less than 9.0?|||

I have the same issue, and I have NEVER had SQL Server 2000 on any server here.

I am only getting this error on one or two of the 7 databases that I have on the SQL server instance.

--

Is there a way to delete the diagramming "stuff" so that when the create... option is chosen in Database Diagrams, it resets all of the sp's, etc.?

|||I'm not familiar with a way to do that. That isn't to say that there isn't one, so we'll leave this post open...Maybe someone will chime in!|||

Hi,

I had this problem as well (SQL 2005) - I simply deleted the sysdiagrams table from System Tables and created a new diagram allowing it to automatically create the database objects. This seemed to solve the problem.

Nick

|||

Hello:

This is what I did....

1. Created a Create Query for the System Tables > dbo.sysdiagrams

2. Changed the following statement:

[diagram_id] [int] DEFAULT((0)),

3. Deleted the table: System Tables > dbo.sysdiagrams

4. Executed the modified query

5. Saved my diagram. It worked fine

6. I was even able to create and open multiple diagrams without any problems!

software786

|||Yes, this works. Ah, why isn't this fixed in SQL Server's updates?

Cannot connect to admin:ServerName

Hi All,
When I try to connect to SQL Server 2005 by using Dedicated administrator
connections by admin:ServerName.
I encounter this error:
Cannot connect to admin:ServerName
Dedicated administrator connections are not supported. (ObjectExplorer)
N.B.:
I use SQL authentication to connect.
SQL authentication is working without the "admin:" prefix.
Thank you.
Bishoy
May be an unrespectable answer.
DAC is enabled and still the problem persists.
Thank you.
"Theo Verweij" wrote:

> Maybe a stupid question, but do you have DAC enabled on this server (it
> is disabled by default)?
> Bishoy wrote:
>
|||If this is remote, you need to make sure to enable remote
admin connections with sp_configure.
But the error indicates you're running into something else.
The DAC is only supported for a query window, it's not
supported with Object Explorer. If trying to connect with a
DAC in SSMS, try opening a regular connection first and then
open a query window with a DAC.
-Sue
On Sun, 5 Nov 2006 10:44:01 -0800, Bishoy
<Bishoy@.discussions.microsoft.com> wrote:

>Hi All,
>When I try to connect to SQL Server 2005 by using Dedicated administrator
>connections by admin:ServerName.
>I encounter this error:
>Cannot connect to admin:ServerName
>Dedicated administrator connections are not supported. (ObjectExplorer)
>N.B.:
>I use SQL authentication to connect.
>SQL authentication is working without the "admin:" prefix.
>Thank you.
>Bishoy
|||Dear Tibor and Sue,
You are just correct.
Actually it works with new query only.
Thank you alot.
Bishoy
|||Hi Bishoy
The error message is very specific. It says you cannot open a DAC connection
to Object Explorer. That is the default when you try to open Management
Studio.
You need to open Management Studio, and then you can open a query window
with the DAC.
Alternatively, you can configure Management Studio to open a Query Window
instead of explorer on startup.
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:2D5006C5-5836-4B83-B680-8D51B378104D@.microsoft.com...
> Hi All,
> When I try to connect to SQL Server 2005 by using Dedicated administrator
> connections by admin:ServerName.
> I encounter this error:
> Cannot connect to admin:ServerName
> Dedicated administrator connections are not supported. (ObjectExplorer)
> N.B.:
> I use SQL authentication to connect.
> SQL authentication is working without the "admin:" prefix.
> Thank you.
> Bishoy

Cannot connect to admin:ServerName

Hi All,

When I try to connect to SQL Server 2005 by using Dedicated administrator connections by admin:ServerName.

I encounter this error:
Cannot connect to admin:ServerName
Dedicated administrator connections are not supported. (ObjectExplorer)

N.B.:
I use SQL authentication to connect.
SQL authentication is working without the "admin:" prefix.

Thank you.
Bishoy

Hi Bishoy,

Make sure you have enabled DAC in the SQL Surface Area Configuration under features. It is disabled by default.

Cheers,

Rob

|||DAC for sqlexpress is disabled by default. Add trace 7806 as part of the startup trace for sqlserver. Restart the service to the effect. Don't forget to enable/start sqlbrowser service too.

See the following kb for more info:
http://msdn2.microsoft.com/en-us/library/ms189595.aspx|||

Robert Varga wrote:

Hi Bishoy,

Make sure you have enabled DAC in the SQL Surface Area Configuration under features. It is disabled by default.

Cheers,

Rob

Thanks for the pointer, no wonder it didn't work when I tried.

Question is, I have enabled DAC on 3 SQL servers, but still cannot connect into them with ADMIN:SERVERNAME

Error is "Dedicated administrator connections are not supported."

Do I need to restart the SQL Server?

Cannot connect to admin:ServerName

Hi All,
When I try to connect to SQL Server 2005 by using Dedicated administrator
connections by admin:ServerName.
I encounter this error:
Cannot connect to admin:ServerName
Dedicated administrator connections are not supported. (ObjectExplorer)
N.B.:
I use SQL authentication to connect.
SQL authentication is working without the "admin:" prefix.
Thank you.
BishoyMaybe a stupid question, but do you have DAC enabled on this server (it
is disabled by default)?
Bishoy wrote:
> Hi All,
> When I try to connect to SQL Server 2005 by using Dedicated administrator
> connections by admin:ServerName.
> I encounter this error:
> Cannot connect to admin:ServerName
> Dedicated administrator connections are not supported. (ObjectExplorer)
> N.B.:
> I use SQL authentication to connect.
> SQL authentication is working without the "admin:" prefix.
> Thank you.
> Bishoy|||May be an unrespectable answer.
DAC is enabled and still the problem persists.
Thank you.
"Theo Verweij" wrote:

> Maybe a stupid question, but do you have DAC enabled on this server (it
> is disabled by default)?
> Bishoy wrote:
>|||> Dedicated administrator connections are not supported. (ObjectExplorer)
Are you trying to open a query window or Object Explorer through the DAC? Yo
u can only have one
connection using the DAC, and Object Explorer can not use the DAC.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:2D5006C5-5836-4B83-B680-8D51B378104D@.microsoft.com...
> Hi All,
> When I try to connect to SQL Server 2005 by using Dedicated administrator
> connections by admin:ServerName.
> I encounter this error:
> Cannot connect to admin:ServerName
> Dedicated administrator connections are not supported. (ObjectExplorer)
> N.B.:
> I use SQL authentication to connect.
> SQL authentication is working without the "admin:" prefix.
> Thank you.
> Bishoy|||If this is remote, you need to make sure to enable remote
admin connections with sp_configure.
But the error indicates you're running into something else.
The DAC is only supported for a query window, it's not
supported with Object Explorer. If trying to connect with a
DAC in SSMS, try opening a regular connection first and then
open a query window with a DAC.
-Sue
On Sun, 5 Nov 2006 10:44:01 -0800, Bishoy
<Bishoy@.discussions.microsoft.com> wrote:

>Hi All,
>When I try to connect to SQL Server 2005 by using Dedicated administrator
>connections by admin:ServerName.
>I encounter this error:
>Cannot connect to admin:ServerName
>Dedicated administrator connections are not supported. (ObjectExplorer)
>N.B.:
>I use SQL authentication to connect.
>SQL authentication is working without the "admin:" prefix.
>Thank you.
>Bishoy|||Dear Tibor and Sue,
You are just correct.
Actually it works with new query only.
Thank you alot.
Bishoy|||I apologize.
Bishoy wrote:[vbcol=seagreen]
> May be an unrespectable answer.
> DAC is enabled and still the problem persists.
> Thank you.
> "Theo Verweij" wrote:
>|||Hi Bishoy
The error message is very specific. It says you cannot open a DAC connection
to Object Explorer. That is the default when you try to open Management
Studio.
You need to open Management Studio, and then you can open a query window
with the DAC.
Alternatively, you can configure Management Studio to open a Query Window
instead of explorer on startup.
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:2D5006C5-5836-4B83-B680-8D51B378104D@.microsoft.com...
> Hi All,
> When I try to connect to SQL Server 2005 by using Dedicated administrator
> connections by admin:ServerName.
> I encounter this error:
> Cannot connect to admin:ServerName
> Dedicated administrator connections are not supported. (ObjectExplorer)
> N.B.:
> I use SQL authentication to connect.
> SQL authentication is working without the "admin:" prefix.
> Thank you.
> Bishoy