SQL Configure: specified

Showing posts with label specified. Show all posts

Wednesday, 7 March 2012

Confusing, non-working db copy in 2005 - "specified subsystem"?

I really wanted to be enthusiastic about SQL Server 2005. I'm not off to a
great start with that. I'm stymied by yet another wizard that is anything
but.
I tried to copy a database from a 2000 server to a 2005 server using the new
"Management Studio" - I got a cryptic message about "Integration SSIS proxy"
accounts not existing and stuff about subsystems, so I looked around
newsgroups, and realized that I had not installed "Integration Services",
needed to make this happen. So I did.
After installing this component, I went into the proxies, to SSIS Package
Execution, got told I had to make a credential, which I went and did... then
it bombed out on me with a "specified @.subsystem_id (11) does not exist"
message. When I tried again, it asserted that the proxy exists... but I
could see no evidence of this new proxy name, nor does it show up in this
newfangled copy wizard afterwords. I tried all this again with a new proxy
name, this time clicking "script" instead of the "OK" button. When I run the
script I still get the message about @.subsystem_id.
This is a real step down from the old DTS wizard... mainly in that I could
get that to work without all these confusing runarounds. Is there anyone who
can help me to get where I need to go with this? I just want to copy some
databases... is there a simple way? Can I, if nothing else, at least copy
and attach? At least that I can understand...
I've never been a fan of the CDW in 2000 or 2005. Much simpler to
backup/restore or detach/attach. Note that this will leave your database in
80 compatability mode so you'll need to run
EXEC sp_dbcmptlevel 'database name', '90'
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Richard K Bethell" <softdev@.spammingisevil.bad> wrote in message
news:OP%23TK1G7FHA.1028@.TK2MSFTNGP11.phx.gbl...
>I really wanted to be enthusiastic about SQL Server 2005. I'm not off to a
>great start with that. I'm stymied by yet another wizard that is anything
>but.
> I tried to copy a database from a 2000 server to a 2005 server using the
> new "Management Studio" - I got a cryptic message about "Integration SSIS
> proxy" accounts not existing and stuff about subsystems, so I looked
> around newsgroups, and realized that I had not installed "Integration
> Services", needed to make this happen. So I did.
> After installing this component, I went into the proxies, to SSIS Package
> Execution, got told I had to make a credential, which I went and did...
> then it bombed out on me with a "specified @.subsystem_id (11) does not
> exist" message. When I tried again, it asserted that the proxy exists...
> but I could see no evidence of this new proxy name, nor does it show up in
> this newfangled copy wizard afterwords. I tried all this again with a new
> proxy name, this time clicking "script" instead of the "OK" button. When I
> run the script I still get the message about @.subsystem_id.
> This is a real step down from the old DTS wizard... mainly in that I could
> get that to work without all these confusing runarounds. Is there anyone
> who can help me to get where I need to go with this? I just want to copy
> some databases... is there a simple way? Can I, if nothing else, at least
> copy and attach? At least that I can understand...
>
|||It appears to have gotten worse in 2005, even. :-) Thanks for the
compatibility tip! I probably would have forgotten about that...
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:OeCleBH7FHA.1140@.tk2msftngp13.phx.gbl...
> I've never been a fan of the CDW in 2000 or 2005. Much simpler to
> backup/restore or detach/attach. Note that this will leave your database
> in 80 compatability mode so you'll need to run
> EXEC sp_dbcmptlevel 'database name', '90'
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Richard K Bethell" <softdev@.spammingisevil.bad> wrote in message
> news:OP%23TK1G7FHA.1028@.TK2MSFTNGP11.phx.gbl...
>
|||I should also have said a couple more things
1) Update all your statistics
2) Run DBCC UPDATEUSAGE (0)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Richard K Bethell" <softdev@.spammingisevil.bad> wrote in message
news:OJMDWSH7FHA.2484@.TK2MSFTNGP10.phx.gbl...
> It appears to have gotten worse in 2005, even. :-) Thanks for the
> compatibility tip! I probably would have forgotten about that...
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:OeCleBH7FHA.1140@.tk2msftngp13.phx.gbl...
>

Friday, 17 February 2012

configuring SQLDataSource with default database

Hello,

I have specified a default database in my web.config like this:

<dataConfigurationdefaultDatabase="scsLocal"/>

<addname="scsLocal"connectionString="server=DRLSWARTEBRV;database=SCS;uid=******;password=******;"providerName="System.Data.SqlClient"/>

</connectionStrings>

Now I would like to configure a SQLDataSource control to use this default database, yet it prompts me for a connectionstring. I know I can program it in the code behind file (if I ommit connection string, it will use the default), but then I can make no use of the wizard for configuring the SQLDataSource which would safe me a lot of coding.

Is there a way to configure the SQLDataSource to use the default database that is specified in the web.config?

Thanks!

Veerle

Veerle:
<dataConfigurationdefaultDatabase="scsLocal"/>

I'm not sure about what you're trying to do with this but you can configure the SQLDataSource in your .aspx page like this:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:<the web.config parameter name>%>"
 SelectCommand="You select query here"
 <SelectParameters>
 <if any>
 </SelectParameters>
 </asp:SqlDataSource>

Hope this will help.

Friday, 10 February 2012

Configure RS in sql express

Reporting Services Log

The Reporting Services installation options you specified in Setup determine whether further configuration is required before you can access the report server. If you installed the default configuration, the report server can be used immediately. If you installed just the program files, you must run the Reporting Services Configuration tool to deploy the report server.
I just installed sql express without sql developer or enterprise edition, I dont see Reporting Services on virtual directorys on IIS. I dont know how to acess the report server and configure it.

Tks

i have the same problem
i serch information about instalation RS on express edition and i find nothink, only info about futures
probably there are no RS in SQL Express setup, maby later...|||But Microsoft has a page where they say sql express has reporting services. Where is it?|||Yes. SQL Server Express has RS. However, not now. it will be available in the first half of the next year.

Alejandro Leguizamo
SQL Server MVP
Colombia|||Thank you Alejandro for answering to my email.

So the solution for this I think will be easy.

I will create my database on sql server express, I also will install sql server 2005 enterprise edition and make the reports in there, when the sql express with reporting services has been released the only thing I need to change will be the deployment options and thats it.

Correct me if I am wrong.|||

We have a client who requires RS 2005 (cause RS2004 has bugs), however is not ready to update to SQL 2005 (yet). The plan was to install Express with RS 2005, however it has been pointed out that RS is not packaged yet.

Is it possible to install Reporting Services off the developer edition cd onto a SQL Express instance? (Without using the developer licence in doing so).

Thanks

David

|||

No, this is not possible. A specific "package" which includes SQL Express and SSRS (Called SQL Server Express Edition with Advanced Services) will be available next year. This "Express SSRS" is the only version that will function against an Express database. I've had a customer or two try what you've suggested already, and it doesn't work.

I'm also not sure this idea would be "legal" (as you'd be putting SQL Developer into production which you may not do until the more recent MSDN SKUS), but that's above and beyond the technical part of the answer, anyway.

Configure RS in sql express

Reporting Services Log

Tks

i have the same problem
i serch information about instalation RS on express edition and i find nothink, only info about futures
probably there are no RS in SQL Express setup, maby later...
|||But Microsoft has a page where they say sql express has reporting services. Where is it?|||Yes. SQL Server Express has RS. However, not now. it will be available in the first half of the next year.

Alejandro Leguizamo
SQL Server MVP
Colombia|||Thank you Alejandro for answering to my email.

So the solution for this I think will be easy.

Correct me if I am wrong.|||

Is it possible to install Reporting Services off the developer edition cd onto a SQL Express instance? (Without using the developer licence in doing so).

Thanks

David

|||

CONFIGURE REPORT SERVER - Initialization button disabled / Key not valid for use in specified st

Hi There,

I am trying to setup a RS with Configure Report Server tool. (Windows 2003 Server / SQL 2005)

* All the items are with green check points except Encryption Keys (Blue exclamation point) and initialization wich is disabled. * Event log shows a lots of errors: Report Server Windows Service (SQL2K5) cannot connect to the report server database. * Browsing the Web Reports Server is returning the errror: Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)

Can someone give me a ideea where to dig next?

Regards,

Toronto,

Canada

Which edition of RS are you using? The initialization button could be disabled because your edition doesn't support scale-out deployment. Does the disabled button show a check mark or a cross?

When you browse http://<server>/reportserver, are there any errors in the log file? Also review what's on the database setup panel. Perhaps try to reapply the settings on the panel. (The cannot connect to report server database error is suspicious considering the database setup panel shows green check mark.)

|||

EDITION:

Initialization button show a cross.

(The cannot connect to report server database error is suspicious considering the database setup panel shows green check mark.) - I totaly agree with you here - this is a paradox.

The database button is green with the check sign and the log is full of:

Report Server Windows Service (SQL2K5) cannot connect to the report server database.

Encryption Keys is blue with exclamation sign. Buttons backup and change disabled, delete and restore available.

Is there any way to post some screenshots of these?

Regards,

Toronto

|||

Scale-out is only supported for Developer, Enterprise and Evaluation edition, so you'd expect the Initialization to be disabled. (However, it should not be a cross.)

The database button is green means that the connection information is set in rsreportserver.config file. It is possible that the connection information is incorrect. Although, if you used the config tool to configure this panel, you should end up with a good connection information. Perhaps you can review http://msdn2.microsoft.com/en-us/ms159133.aspx. After reapplying the settings, check if your RS catalog databases is granted the correct permissions. Perhaps you can also check from the SQL profiler if your database is getting hit, and if the logons are denied.

|||

RS service is running under the same Windows account wich is designated for SQL server service. This account is part of Administrators group on OS and on SQL instance.

Does RS service require a distinct account?

I have loged in the server with the Windows account above mentioned.

I have accesse the RS database and the RSTemp database with no problem.

What else is missing?

Wednesday, 7 March 2012

Confusing, non-working db copy in 2005 - "specified subsystem"?

Friday, 17 February 2012

configuring SQLDataSource with default database

Friday, 10 February 2012

Configure RS in sql express

Configure RS in sql express

CONFIGURE REPORT SERVER - Initialization button disabled / Key not valid for use in specified st

SQL Configure

Blog Archive

About Me