Cannot create diagram in SQL 2005

i get the following message

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.

I am the db owner but still wouldnt let me install and create diagrams.

help!

cheers

I moved this thread from SSIS forum...I hope you can get better luck here...|||

hey i found the answer

you gotta set the owner to sa and then go to the database properties, then options, then change compatibility fromn sql 2000 (80) to sql 2005 (90)

too easy..

thanks buddy

Cannot create a valid ODBC DSN to SQL Server Express

Hello All,

I've just spent the better part of a day trying to configure SQL Express to allow me to create an ODBC connection. When I do create one via Control Panel/Admin/ODBC it tells me that its timing out on the connection (localhost) and the problem is probably that SQL Server Express comes configured NOT to allow remote connections. I've enabled TCP/IP and named pipes, allowed remote connections, enabled the SQL Browser, and just about everything I;ve read in the docs and forums.

Am I missing the obvious?

Kind Regards,

Pat.

Pat,

I guess you are using (localhost) as the target server which is invalid. Either you can use (local)\sqlexpress or localhost\sqlexpress to connect to local sql express instance, a name instance.

Thanks,

Nan

|||

Nan,

You are bang on! Thank you very much.

I've created a test user database, but when i attempt to "get external data/link tables" in access, I can't see my database, only all the system tables.

Any thoughts?

Kind Regards,

Pat.

|||

Did you specify your database name while creating DSN?

It's under 'Change the default dabase to' checkbox.

|||

Thank you, gavrilenko_s - that did it.

To both you and Nan, if in Dublin, send me an email - there are pints of guinness woith your names on them.

appreciatively,

Pat Backowski

Consider this thread closed and solved - well done, lads!

|||Holy Telemundo, Batman! If I hadn't found this thread, I was seriously considering just using MySQL for my app. I've talked to a few guys who have had this problem too. You may want to include a hint about this solution in the next revision of the connectivity tools so people don't go wasting so much time on what could have been a simple solution.

Cannot create a valid ODBC DSN to SQL Server Express

Hello All,

I've just spent the better part of a day trying to configure SQL Express to allow me to create an ODBC connection. When I do create one via Control Panel/Admin/ODBC it tells me that its timing out on the connection (localhost) and the problem is probably that SQL Server Express comes configured NOT to allow remote connections. I've enabled TCP/IP and named pipes, allowed remote connections, enabled the SQL Browser, and just about everything I;ve read in the docs and forums.

Am I missing the obvious?

Kind Regards,

Pat.

Pat,

I guess you are using (localhost) as the target server which is invalid. Either you can use (local)\sqlexpress or localhost\sqlexpress to connect to local sql express instance, a name instance.

Thanks,

Nan

|||

Nan,

You are bang on! Thank you very much.

I've created a test user database, but when i attempt to "get external data/link tables" in access, I can't see my database, only all the system tables.

Any thoughts?

Kind Regards,

Pat.

|||

Did you specify your database name while creating DSN?

It's under 'Change the default dabase to' checkbox.

|||

Thank you, gavrilenko_s - that did it.

To both you and Nan, if in Dublin, send me an email - there are pints of guinness woith your names on them.

appreciatively,

Pat Backowski

Consider this thread closed and solved - well done, lads!

|||Holy Telemundo, Batman! If I hadn't found this thread, I was seriously considering just using MySQL for my app. I've talked to a few guys who have had this problem too. You may want to include a hint about this solution in the next revision of the connectivity tools so people don't go wasting so much time on what could have been a simple solution.

Cannot create a file through a file share subscription

Hi
I am trying to create a file share subscription for a report. I have
specified a valid unc path for the file.
When the schedule is run ny SQL Agent, it returns the following error:
"Failure writing file Depth Distribution : The Report Server has encountered
a configuration error; more details in the log files"
When I look at the log file, there is no error indicated. It just says the
following:
w3wp!subscription!1ec4!05/04/2005-15:26:58:: Subscription Created for report
/TRACKERS Templates/Dist Tracker Template/Depth Distribution at
2005-05-04T15:26:58 by NSchneider
w3wp!library!1358!05/04/2005-15:26:59:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:26:59:: i INFO: Call to GetSystemPermissions
w3wp!library!1ec4!05/04/2005-15:27:02:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1ec4!05/04/2005-15:27:02:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:02:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:02:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:03:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:03:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:04:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:04:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:06:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:06:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:09:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:09:: i INFO: Call to GetSystemPermissions
w3wp!library!1ec4!05/04/2005-15:27:09:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1ec4!05/04/2005-15:27:09:: i INFO: Call to GetSystemPermissions
w3wp!library!1358!05/04/2005-15:27:10:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1358!05/04/2005-15:27:10:: i INFO: Call to GetSystemPermissions
w3wp!library!1ec4!05/04/2005-15:27:10:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1ec4!05/04/2005-15:27:10:: i INFO: Call to GetSystemPermissions
w3wp!library!1ec4!05/04/2005-15:27:11:: i INFO: Call to
GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
w3wp!library!1ec4!05/04/2005-15:27:11:: i INFO: Call to GetSystemPermissions
Does anyone know what is going on here?
Thanking you in advanceHi,
This could be a permission issue. Make sure the account executed the
subscription is in local user account and has access permission to the share
path.
Charles
"PORRASTAR" wrote:
> Hi
> I am trying to create a file share subscription for a report. I have
> specified a valid unc path for the file.
> When the schedule is run ny SQL Agent, it returns the following error:
> "Failure writing file Depth Distribution : The Report Server has encountered
> a configuration error; more details in the log files"
> When I look at the log file, there is no error indicated. It just says the
> following:
> w3wp!subscription!1ec4!05/04/2005-15:26:58:: Subscription Created for report
> /TRACKERS Templates/Dist Tracker Template/Depth Distribution at
> 2005-05-04T15:26:58 by NSchneider
> w3wp!library!1358!05/04/2005-15:26:59:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:26:59:: i INFO: Call to GetSystemPermissions
> w3wp!library!1ec4!05/04/2005-15:27:02:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1ec4!05/04/2005-15:27:02:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:02:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:02:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:03:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:03:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:04:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:04:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:05:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:06:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:06:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:09:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:09:: i INFO: Call to GetSystemPermissions
> w3wp!library!1ec4!05/04/2005-15:27:09:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1ec4!05/04/2005-15:27:09:: i INFO: Call to GetSystemPermissions
> w3wp!library!1358!05/04/2005-15:27:10:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1358!05/04/2005-15:27:10:: i INFO: Call to GetSystemPermissions
> w3wp!library!1ec4!05/04/2005-15:27:10:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1ec4!05/04/2005-15:27:10:: i INFO: Call to GetSystemPermissions
> w3wp!library!1ec4!05/04/2005-15:27:11:: i INFO: Call to
> GetPermissions:/TRACKERS Templates/Dist Tracker Template/Depth Distribution
> w3wp!library!1ec4!05/04/2005-15:27:11:: i INFO: Call to GetSystemPermissions
> Does anyone know what is going on here?
> Thanking you in advance
>