HELP I CANNOT DEPLOPY WITH REPORT SERVICES AND SQL SERVER 2005 EXPRES ADVANCE

Hi I had installed SQL Server 2005 Express Avanced and busines intellegence development studio express. in my windows XP profesional

I have ready my first report, and When I want deploy , the system say: Reporting Services Loign: User name & Password.

I don't know that user and password must write!!!

Please can someone help me!!!

thanks folks

david

spain

Moving to the Reporting Services forum.

Mike

sql

Help abt reporting services

Hi,
I have VS 2005 and SQL Server 2005 installed.How do i create reports
using Reporting Services '
I can't find any tab like " Reporting Services" under File | new |
project .
What should I do 'R wrote:
> Hi,
>
> I have VS 2005 and SQL Server 2005 installed.How do i create reports
> using Reporting Services '
> I can't find any tab like " Reporting Services" under File | new |
> project .
> What should I do '
In VS2005, Create an empty solution, then in this solution add a new
project.
Under project types you should see "Business Intelligence Projects"
under project types.
Select this, then you can select "Report Server Project"
You can then create your reports and data sources as required, and
deploy to your report server.|||Have you installed the client tools? If you installed SQL 2005 on your
computer that does not install the client tools. You have to run setup
separately for that.
If you installed the client tools prior to VS 2005 then you need to install
them again.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"R" <rashmi.bhandarkar@.gmail.com> wrote in message
news:1166503957.547110.245550@.73g2000cwn.googlegroups.com...
> Hi,
>
> I have VS 2005 and SQL Server 2005 installed.How do i create reports
> using Reporting Services '
> I can't find any tab like " Reporting Services" under File | new |
> project .
> What should I do '
>

HELP !!!!

Hey,

I've installed the reporting services with the SQL EXPRESS 2005.

I've succeed to make some reports, and now i want to deploy them.

When i'm trying to run the reporting services configuration manger, i get the message "bad namespace". ican't connect in the instalation window to any machine that i'm trying to connect.

iI've tried to connect my computer, other computers with SQLEXPRESS and with SQL 2000, but i didn't succed.

How i should configure the report server ?

please, help !

Please HELP S.O.S !!!!

HELP - SRS for Developer Ed installed instead of for Standard Ed.

I have been getting ready to finally put into my company's Production
Environment all the reports I have been developing in our Test Environment.
The Test Environment is SQL 2000 Developer Edition, and SRS was installed via
the CD that came in the box - I read that it said "For SQL Server 2000
Developer Edition only."
The decision was made that we did not need Enterprise Edition features, so a
Standard Edition SQL Server 2000 license was purchased and installed, be my
supervisor. He then used the SAME CD for SRS to install that I did. His
logic was "These Microsoft disks can detect what version of SQL Server is
running, and only install the components for the version detected."
I was unaware of this and have been loading the new server with reports and
running the Report Snapshots for the LONG RUNNING REPORTS, and setting up the
Shared Schedules and Permissions for the 125+ reports. I was about to start
creating the Manual Subscriptions for the various reports when I noticed the
'New Data-driven Subscription' button, and then realized what happened.
I would like to avoid redoing work, if possible. Is there a way to
over-install the Standard Edition Version of SQL Reporting Services on top of
the Developer Edition, so I don't have to re-setup everything? Is there a
way to downgrade/upgrade Editions without having to re-build the site?It is possible to do this. Before starting anything, of course, backup your
databases and the report server encryption key (see help topics on backing
up report server).
1. Uninstall the developer edition (this will not remove the report server
databases)
2. Install the standard edition. When asked for a database, use a new one.
Do NOT use the one from the developer install
3. After installation is complete, run rsconfig to point the new
installation at the old database
4. Delete the temporary database that you created as part of step 2.
If you created any data driven subscriptions, they will no longer run with
standard installed.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Rob 'Spike' Stevens" <RobSpikeStevens@.discussions.microsoft.com> wrote in
message news:060F4BF0-885C-45A6-A871-3BBC19EF6617@.microsoft.com...
> I have been getting ready to finally put into my company's Production
> Environment all the reports I have been developing in our Test
Environment.
> The Test Environment is SQL 2000 Developer Edition, and SRS was installed
via
> the CD that came in the box - I read that it said "For SQL Server 2000
> Developer Edition only."
> The decision was made that we did not need Enterprise Edition features, so
a
> Standard Edition SQL Server 2000 license was purchased and installed, be
my
> supervisor. He then used the SAME CD for SRS to install that I did. His
> logic was "These Microsoft disks can detect what version of SQL Server is
> running, and only install the components for the version detected."
> I was unaware of this and have been loading the new server with reports
and
> running the Report Snapshots for the LONG RUNNING REPORTS, and setting up
the
> Shared Schedules and Permissions for the 125+ reports. I was about to
start
> creating the Manual Subscriptions for the various reports when I noticed
the
> 'New Data-driven Subscription' button, and then realized what happened.
> I would like to avoid redoing work, if possible. Is there a way to
> over-install the Standard Edition Version of SQL Reporting Services on top
of
> the Developer Edition, so I don't have to re-setup everything? Is there a
> way to downgrade/upgrade Editions without having to re-build the site?|||I followed your instructions, except I hadn't yet deleted the 'temp' database
yet - didn't want to get rid of it until I knew things are working. They
aren't. I get the following error now:
This edition of Reporting Services does not support web farm deployment.
(rsInvalidRSEditionConfiguration) Get Online Help
Online help says the following:
You cannot use the Standard edition of Reporting Services to deploy multiple
report servers in a Web farms.
I am not using a Web Farm. I have one server that houses the source
databases for my company, and this SRS server that hosts the IIS website and
the SRS databases, both with standard edition. The RDS file points to the
source database server. Is this what SRS consideres a Web Farm? According
to your schemeatics on Reporting Services I have a proper license for both
servers.
"Brian Hartman [MSFT]" wrote:
> It is possible to do this. Before starting anything, of course, backup your
> databases and the report server encryption key (see help topics on backing
> up report server).
> 1. Uninstall the developer edition (this will not remove the report server
> databases)
> 2. Install the standard edition. When asked for a database, use a new one.
> Do NOT use the one from the developer install
> 3. After installation is complete, run rsconfig to point the new
> installation at the old database
> 4. Delete the temporary database that you created as part of step 2.
> If you created any data driven subscriptions, they will no longer run with
> standard installed.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Rob 'Spike' Stevens" <RobSpikeStevens@.discussions.microsoft.com> wrote in
> message news:060F4BF0-885C-45A6-A871-3BBC19EF6617@.microsoft.com...
> > I have been getting ready to finally put into my company's Production
> > Environment all the reports I have been developing in our Test
> Environment.
> > The Test Environment is SQL 2000 Developer Edition, and SRS was installed
> via
> > the CD that came in the box - I read that it said "For SQL Server 2000
> > Developer Edition only."
> >
> > The decision was made that we did not need Enterprise Edition features, so
> a
> > Standard Edition SQL Server 2000 license was purchased and installed, be
> my
> > supervisor. He then used the SAME CD for SRS to install that I did. His
> > logic was "These Microsoft disks can detect what version of SQL Server is
> > running, and only install the components for the version detected."
> >
> > I was unaware of this and have been loading the new server with reports
> and
> > running the Report Snapshots for the LONG RUNNING REPORTS, and setting up
> the
> > Shared Schedules and Permissions for the 125+ reports. I was about to
> start
> > creating the Manual Subscriptions for the various reports when I noticed
> the
> > 'New Data-driven Subscription' button, and then realized what happened.
> >
> > I would like to avoid redoing work, if possible. Is there a way to
> > over-install the Standard Edition Version of SQL Reporting Services on top
> of
> > the Developer Edition, so I don't have to re-setup everything? Is there a
> > way to downgrade/upgrade Editions without having to re-build the site?
>
>|||I went ahead and deleted the new 'temp' databases after running rsconfig
again. I still get the same errors listed below.
"Rob 'Spike' Stevens" wrote:
> I followed your instructions, except I hadn't yet deleted the 'temp' database
> yet - didn't want to get rid of it until I knew things are working. They
> aren't. I get the following error now:
> This edition of Reporting Services does not support web farm deployment.
> (rsInvalidRSEditionConfiguration) Get Online Help
> Online help says the following:
> You cannot use the Standard edition of Reporting Services to deploy multiple
> report servers in a Web farms.
> I am not using a Web Farm. I have one server that houses the source
> databases for my company, and this SRS server that hosts the IIS website and
> the SRS databases, both with standard edition. The RDS file points to the
> source database server. Is this what SRS consideres a Web Farm? According
> to your schemeatics on Reporting Services I have a proper license for both
> servers.
> "Brian Hartman [MSFT]" wrote:
> > It is possible to do this. Before starting anything, of course, backup your
> > databases and the report server encryption key (see help topics on backing
> > up report server).
> >
> > 1. Uninstall the developer edition (this will not remove the report server
> > databases)
> > 2. Install the standard edition. When asked for a database, use a new one.
> > Do NOT use the one from the developer install
> > 3. After installation is complete, run rsconfig to point the new
> > installation at the old database
> > 4. Delete the temporary database that you created as part of step 2.
> >
> > If you created any data driven subscriptions, they will no longer run with
> > standard installed.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights
> >
> > "Rob 'Spike' Stevens" <RobSpikeStevens@.discussions.microsoft.com> wrote in
> > message news:060F4BF0-885C-45A6-A871-3BBC19EF6617@.microsoft.com...
> > > I have been getting ready to finally put into my company's Production
> > > Environment all the reports I have been developing in our Test
> > Environment.
> > > The Test Environment is SQL 2000 Developer Edition, and SRS was installed
> > via
> > > the CD that came in the box - I read that it said "For SQL Server 2000
> > > Developer Edition only."
> > >
> > > The decision was made that we did not need Enterprise Edition features, so
> > a
> > > Standard Edition SQL Server 2000 license was purchased and installed, be
> > my
> > > supervisor. He then used the SAME CD for SRS to install that I did. His
> > > logic was "These Microsoft disks can detect what version of SQL Server is
> > > running, and only install the components for the version detected."
> > >
> > > I was unaware of this and have been loading the new server with reports
> > and
> > > running the Report Snapshots for the LONG RUNNING REPORTS, and setting up
> > the
> > > Shared Schedules and Permissions for the 125+ reports. I was about to
> > start
> > > creating the Manual Subscriptions for the various reports when I noticed
> > the
> > > 'New Data-driven Subscription' button, and then realized what happened.
> > >
> > > I would like to avoid redoing work, if possible. Is there a way to
> > > over-install the Standard Edition Version of SQL Reporting Services on top
> > of
> > > the Developer Edition, so I don't have to re-setup everything? Is there a
> > > way to downgrade/upgrade Editions without having to re-build the site?
> >
> >
> >|||Also, Iâ'm finding this error message in the application log:
Reporting Services components from different editions cannot be used together.
"Rob 'Spike' Stevens" wrote:
> I went ahead and deleted the new 'temp' databases after running rsconfig
> again. I still get the same errors listed below.
> "Rob 'Spike' Stevens" wrote:
> > I followed your instructions, except I hadn't yet deleted the 'temp' database
> > yet - didn't want to get rid of it until I knew things are working. They
> > aren't. I get the following error now:
> >
> > This edition of Reporting Services does not support web farm deployment.
> > (rsInvalidRSEditionConfiguration) Get Online Help
> >
> > Online help says the following:
> > You cannot use the Standard edition of Reporting Services to deploy multiple
> > report servers in a Web farms.
> >
> > I am not using a Web Farm. I have one server that houses the source
> > databases for my company, and this SRS server that hosts the IIS website and
> > the SRS databases, both with standard edition. The RDS file points to the
> > source database server. Is this what SRS consideres a Web Farm? According
> > to your schemeatics on Reporting Services I have a proper license for both
> > servers.
> >
> > "Brian Hartman [MSFT]" wrote:
> >
> > > It is possible to do this. Before starting anything, of course, backup your
> > > databases and the report server encryption key (see help topics on backing
> > > up report server).
> > >
> > > 1. Uninstall the developer edition (this will not remove the report server
> > > databases)
> > > 2. Install the standard edition. When asked for a database, use a new one.
> > > Do NOT use the one from the developer install
> > > 3. After installation is complete, run rsconfig to point the new
> > > installation at the old database
> > > 4. Delete the temporary database that you created as part of step 2.
> > >
> > > If you created any data driven subscriptions, they will no longer run with
> > > standard installed.
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no rights
> > >
> > > "Rob 'Spike' Stevens" <RobSpikeStevens@.discussions.microsoft.com> wrote in
> > > message news:060F4BF0-885C-45A6-A871-3BBC19EF6617@.microsoft.com...
> > > > I have been getting ready to finally put into my company's Production
> > > > Environment all the reports I have been developing in our Test
> > > Environment.
> > > > The Test Environment is SQL 2000 Developer Edition, and SRS was installed
> > > via
> > > > the CD that came in the box - I read that it said "For SQL Server 2000
> > > > Developer Edition only."
> > > >
> > > > The decision was made that we did not need Enterprise Edition features, so
> > > a
> > > > Standard Edition SQL Server 2000 license was purchased and installed, be
> > > my
> > > > supervisor. He then used the SAME CD for SRS to install that I did. His
> > > > logic was "These Microsoft disks can detect what version of SQL Server is
> > > > running, and only install the components for the version detected."
> > > >
> > > > I was unaware of this and have been loading the new server with reports
> > > and
> > > > running the Report Snapshots for the LONG RUNNING REPORTS, and setting up
> > > the
> > > > Shared Schedules and Permissions for the 125+ reports. I was about to
> > > start
> > > > creating the Manual Subscriptions for the various reports when I noticed
> > > the
> > > > 'New Data-driven Subscription' button, and then realized what happened.
> > > >
> > > > I would like to avoid redoing work, if possible. Is there a way to
> > > > over-install the Standard Edition Version of SQL Reporting Services on top
> > > of
> > > > the Developer Edition, so I don't have to re-setup everything? Is there a
> > > > way to downgrade/upgrade Editions without having to re-build the site?
> > >
> > >
> > >|||I was able to find a solution. Thanks for the help you did provide.
"Rob 'Spike' Stevens" wrote:
> Also, Iâ'm finding this error message in the application log:
> Reporting Services components from different editions cannot be used together.
>
> "Rob 'Spike' Stevens" wrote:
> > I went ahead and deleted the new 'temp' databases after running rsconfig
> > again. I still get the same errors listed below.
> >
> > "Rob 'Spike' Stevens" wrote:
> >
> > > I followed your instructions, except I hadn't yet deleted the 'temp' database
> > > yet - didn't want to get rid of it until I knew things are working. They
> > > aren't. I get the following error now:
> > >
> > > This edition of Reporting Services does not support web farm deployment.
> > > (rsInvalidRSEditionConfiguration) Get Online Help
> > >
> > > Online help says the following:
> > > You cannot use the Standard edition of Reporting Services to deploy multiple
> > > report servers in a Web farms.
> > >
> > > I am not using a Web Farm. I have one server that houses the source
> > > databases for my company, and this SRS server that hosts the IIS website and
> > > the SRS databases, both with standard edition. The RDS file points to the
> > > source database server. Is this what SRS consideres a Web Farm? According
> > > to your schemeatics on Reporting Services I have a proper license for both
> > > servers.
> > >
> > > "Brian Hartman [MSFT]" wrote:
> > >
> > > > It is possible to do this. Before starting anything, of course, backup your
> > > > databases and the report server encryption key (see help topics on backing
> > > > up report server).
> > > >
> > > > 1. Uninstall the developer edition (this will not remove the report server
> > > > databases)
> > > > 2. Install the standard edition. When asked for a database, use a new one.
> > > > Do NOT use the one from the developer install
> > > > 3. After installation is complete, run rsconfig to point the new
> > > > installation at the old database
> > > > 4. Delete the temporary database that you created as part of step 2.
> > > >
> > > > If you created any data driven subscriptions, they will no longer run with
> > > > standard installed.
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no rights
> > > >
> > > > "Rob 'Spike' Stevens" <RobSpikeStevens@.discussions.microsoft.com> wrote in
> > > > message news:060F4BF0-885C-45A6-A871-3BBC19EF6617@.microsoft.com...
> > > > > I have been getting ready to finally put into my company's Production
> > > > > Environment all the reports I have been developing in our Test
> > > > Environment.
> > > > > The Test Environment is SQL 2000 Developer Edition, and SRS was installed
> > > > via
> > > > > the CD that came in the box - I read that it said "For SQL Server 2000
> > > > > Developer Edition only."
> > > > >
> > > > > The decision was made that we did not need Enterprise Edition features, so
> > > > a
> > > > > Standard Edition SQL Server 2000 license was purchased and installed, be
> > > > my
> > > > > supervisor. He then used the SAME CD for SRS to install that I did. His
> > > > > logic was "These Microsoft disks can detect what version of SQL Server is
> > > > > running, and only install the components for the version detected."
> > > > >
> > > > > I was unaware of this and have been loading the new server with reports
> > > > and
> > > > > running the Report Snapshots for the LONG RUNNING REPORTS, and setting up
> > > > the
> > > > > Shared Schedules and Permissions for the 125+ reports. I was about to
> > > > start
> > > > > creating the Manual Subscriptions for the various reports when I noticed
> > > > the
> > > > > 'New Data-driven Subscription' button, and then realized what happened.
> > > > >
> > > > > I would like to avoid redoing work, if possible. Is there a way to
> > > > > over-install the Standard Edition Version of SQL Reporting Services on top
> > > > of
> > > > > the Developer Edition, so I don't have to re-setup everything? Is there a
> > > > > way to downgrade/upgrade Editions without having to re-build the site?
> > > >
> > > >
> > > >

HELP - SQL Server 2000 Install Files needed urgently

Hi!

I have a large project that is due to complete this week. In order to
complete it I need SQL Server 2000 installed on a remote server. My
disk is corrupt and to order another media disk would damage my
deadline. I have the licence and serial key, but now need good install
files. I am even ready to buy another retail box, if I can find a
supplier that would give me a download site for the media, while I wait
for the shipment!

Please PLEASE help!

Regards,

BarryHi,

Sorry if i'm stating the obvious - but it wasn't commented on in your
post.. If you have the licence and serial key shouldn't you be
contacting Microsoft?

Greg|||Hi Greg. They will send me another media disk, but that doesnt help me
getting it installed for tomorrow.

Thanks for your reply.

Barry|||"TheFoot" <workshop@.carib-sys.com> wrote in message
news:1112918510.565481.327210@.g14g2000cwa.googlegr oups.com...
> Hi Greg. They will send me another media disk, but that doesnt help me
> getting it installed for tomorrow.

Unfortuantely I doubt most anyone here would be comfortable putting binaries
out there to be copied. Even if you're totally legit, MS would have a field
day if they found out.

Sorry.

> Thanks for your reply.
> Barry|||"TheFoot" <workshop@.carib-sys.com> wrote in message
news:1112918510.565481.327210@.g14g2000cwa.googlegr oups.com...
> Hi Greg. They will send me another media disk, but that doesnt help me
> getting it installed for tomorrow.
> Thanks for your reply.

Oh, one other thought.. may be too late by an hour or two, but a couple of
places like PC Connection on the East coast used to have a "order by
midnight and get it the next day" policy. MIGHT have luck with them.

> Barry|||I agree with Greg, nobody's going to "lend" you the SQL Server binaries
based on the premise that you're entitled to them - too much personal
risk.

I see two options:

1. Delay the project and wait for the shipment
2. Incur the extra cost for the "retail box" and hopefully charge it
back to the business|||Download the eval and then upgrade later.

http://www.microsoft.com/sql/evalua...ial/default.asp

--
David Portas
SQL Server MVP
--

Help - problem with running SQL Server Management Studio Express CTP

I just installed SQL Server Management Studio Express CTP on a new XP Pro machine. SSMSECTP is present in the program list but nothing happens when I select it. What do I do to fix this? I don't have any type of interface to the SQL Server databases, although the Configuration Manager works OK.Problem solved - I uninstalled everything except MS .NET Framework 2.0 and then reinstalled everything. After this SSMSECTP came up OK.

HELP - Connecting SQL Express Edition

I have two machines and same problem.
I installed SQL EE on XP HOME EDITION it is OK !
Localy work OK !
I try to connect from another machine with SQL Server Management Studio and
I can't.
I some how successed to connect with named pipes but TCP/IP is not working.
I turn on all protocols with Menager. Shout down firewall on both machines.
I tried with SQL Native Client from code but nothing.
For now anly named pipes working.
What is wrong ?Have a look at these:
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/a.../05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access
http://msdn.microsoft.com/library/d...r />
rview.asp
Express Overview
http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing Express
with MSDE
http://msdn.microsoft.com/sql/defau... />
erinst.asp
User Instances
http://msdn.microsoft.com/sql/expre...qlexcustapp.asp
Embedding Express in Apps
http://blogs.msdn.com/rogerwolterbl.../13/575974.aspx
Backing up Express
Automating Database maintenance in SQL 2005 Express Edition Part I
http://www.sqldbatips.com/showarticle.asp?ID=27
Automating Database maintenance in SQL 2005 Express Edition Part II
http://www.sqldbatips.com/showarticle.asp?ID=29
Andrew J. Kelly SQL MVP
"Soko" <sokcic@.hotmail.com> wrote in message
news:eQqmarSiGHA.4660@.TK2MSFTNGP03.phx.gbl...
>I have two machines and same problem.
> I installed SQL EE on XP HOME EDITION it is OK !
> Localy work OK !
> I try to connect from another machine with SQL Server Management Studio
> and I can't.
> I some how successed to connect with named pipes but TCP/IP is not
> working.
> I turn on all protocols with Menager. Shout down firewall on both
> machines.
> I tried with SQL Native Client from code but nothing.
> For now anly named pipes working.
> What is wrong ?
>|||Hi Soko,
I have a very similar (if not the same problem). Have you actually solve it?
Thanks
Zib
From http://www.developmentnow.com/g/100...ess-Edition.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com|||SQL Server Express installs as a named instance. Unless you change it the
instance is called <computername>\SQLExpress.
The SQL Server Browser service resolves the name, to the TCP/IP port number.
I suspect the SQL Server Browser service is not running on your computer. If
you start it, then you may be able to connect.
"Soko" <sokcic@.hotmail.com> wrote in message
news:eQqmarSiGHA.4660@.TK2MSFTNGP03.phx.gbl...
>I have two machines and same problem.
> I installed SQL EE on XP HOME EDITION it is OK !
> Localy work OK !
> I try to connect from another machine with SQL Server Management Studio
> and I can't.
> I some how successed to connect with named pipes but TCP/IP is not
> working.
> I turn on all protocols with Menager. Shout down firewall on both
> machines.
> I tried with SQL Native Client from code but nothing.
> For now anly named pipes working.
> What is wrong ?
>

HELP - Cannot connect to SQL Server 2005 Express

I've installed the SQL Server 2005 Express and also the MS SQL Server Management Studio 2005 Express
But when i load the latter and try to connect to my database I get the below error message.

TITLE: Connect to Server

Cannot connect to DEVCOMP\SQLEXPRESS.

ADDITIONAL INFORMATION:
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) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
Further Details:

Further to the above error me, I got the following when I clicked on "Surface Area Configuration for Services and Connections"

TITLE: Surface Area Configuration for Services and Connections - localhost
-
Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again.
-
ADDITIONAL INFORMATION:
[C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SmoEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SmoEnum.dll] InternalsVisibleTo declarations cannot have a version, culture, public key token, or processor architecture specified. (Microsoft.SqlServer.Smo)
-

|||Check to see if the SQL Server Express service is started.

Also, you may want to change the network settings to accept TCP/IP and remote connections. Check out this blog entry:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Let me know if this doesn't fix your problem.

Thanks,
Rob|||

The remote connectivity is disabled by default. You can activate it using the SQL Server 2005 Surface Area Configuration SQLSAC.EXE.

If localhost is not known, then either your hosts. file is corrupt or blocked by a firewall (for any tests, deactivate the local firewall temporarily). You can use 127.0.0.1 instead of localhost.

The hosts file is located in your windows directory under

C:\windows\system32\drivers\etc\hosts.

Regards
Axel

|||

I have checked out the blog and performed all the steps. I have restarted the services and still no luck.

I am a newbie to webdev so started with the sample personal website. I followed the instructions to the letter but cant get past Ctrl-F5 to initialize without the error.

Where do I goto from here?

Paul

HELP - Cannot connect to SQL Server 2005 Express

I've installed the SQL Server 2005 Express and also the MS SQL Server Management Studio 2005 Express
But when i load the latter and try to connect to my database I get the below error message.

TITLE: Connect to Server

Cannot connect to DEVCOMP\SQLEXPRESS.

ADDITIONAL INFORMATION:
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) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
Further Details:

Further to the above error me, I got the following when I clicked on "Surface Area Configuration for Services and Connections"

TITLE: Surface Area Configuration for Services and Connections - localhost
-
Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again.
-
ADDITIONAL INFORMATION:
[C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SmoEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SmoEnum.dll] InternalsVisibleTo declarations cannot have a version, culture, public key token, or processor architecture specified. (Microsoft.SqlServer.Smo)
-

|||Check to see if the SQL Server Express service is started.

Also, you may want to change the network settings to accept TCP/IP and remote connections. Check out this blog entry:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Let me know if this doesn't fix your problem.

Thanks,
Rob|||

The remote connectivity is disabled by default. You can activate it using the SQL Server 2005 Surface Area Configuration SQLSAC.EXE.

If localhost is not known, then either your hosts. file is corrupt or blocked by a firewall (for any tests, deactivate the local firewall temporarily). You can use 127.0.0.1 instead of localhost.

The hosts file is located in your windows directory under

C:\windows\system32\drivers\etc\hosts.

Regards
Axel

|||

I have checked out the blog and performed all the steps. I have restarted the services and still no luck.

I am a newbie to webdev so started with the sample personal website. I followed the instructions to the letter but cant get past Ctrl-F5 to initialize without the error.

Where do I goto from here?

Paul

HELP - Cannot connect to SQL Server 2005 Express

I've installed the SQL Server 2005 Express and also the MS SQL Server Management Studio 2005 Express
But when i load the latter and try to connect to my database I get the below error message.

TITLE: Connect to Server

Cannot connect to DEVCOMP\SQLEXPRESS.

ADDITIONAL INFORMATION:
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) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
Further Details:

Further to the above error me, I got the following when I clicked on "Surface Area Configuration for Services and Connections"

TITLE: Surface Area Configuration for Services and Connections - localhost
-
Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again.
-
ADDITIONAL INFORMATION:
[C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SmoEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SmoEnum.dll] InternalsVisibleTo declarations cannot have a version, culture, public key token, or processor architecture specified. (Microsoft.SqlServer.Smo)
-

|||Check to see if the SQL Server Express service is started.

Also, you may want to change the network settings to accept TCP/IP and remote connections. Check out this blog entry:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Let me know if this doesn't fix your problem.

Thanks,
Rob|||

The remote connectivity is disabled by default. You can activate it using the SQL Server 2005 Surface Area Configuration SQLSAC.EXE.

If localhost is not known, then either your hosts. file is corrupt or blocked by a firewall (for any tests, deactivate the local firewall temporarily). You can use 127.0.0.1 instead of localhost.

The hosts file is located in your windows directory under

C:\windows\system32\drivers\etc\hosts.

Regards
Axel

|||

I have checked out the blog and performed all the steps. I have restarted the services and still no luck.

I am a newbie to webdev so started with the sample personal website. I followed the instructions to the letter but cant get past Ctrl-F5 to initialize without the error.

Where do I goto from here?

Paul

HELP - Cannot connect to SQL Server 2005 Express

I've installed the SQL Server 2005 Express and also the MS SQL Server Management Studio 2005 Express
But when i load the latter and try to connect to my database I get the below error message.

TITLE: Connect to Server

Cannot connect to DEVCOMP\SQLEXPRESS.

ADDITIONAL INFORMATION:
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) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
Further Details:

Further to the above error me, I got the following when I clicked on "Surface Area Configuration for Services and Connections"

TITLE: Surface Area Configuration for Services and Connections - localhost
-
Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again.
-
ADDITIONAL INFORMATION:
[C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SmoEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SmoEnum.dll] InternalsVisibleTo declarations cannot have a version, culture, public key token, or processor architecture specified. (Microsoft.SqlServer.Smo)
-

|||Check to see if the SQL Server Express service is started.

Also, you may want to change the network settings to accept TCP/IP and remote connections. Check out this blog entry:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Let me know if this doesn't fix your problem.

Thanks,
Rob|||

The remote connectivity is disabled by default. You can activate it using the SQL Server 2005 Surface Area Configuration SQLSAC.EXE.

If localhost is not known, then either your hosts. file is corrupt or blocked by a firewall (for any tests, deactivate the local firewall temporarily). You can use 127.0.0.1 instead of localhost.

The hosts file is located in your windows directory under

C:\windows\system32\drivers\etc\hosts.

Regards
Axel

|||

I have checked out the blog and performed all the steps. I have restarted the services and still no luck.

I am a newbie to webdev so started with the sample personal website. I followed the instructions to the letter but cant get past Ctrl-F5 to initialize without the error.

Where do I goto from here?

Paul

Help

I just want to discuss one thing with you like we have implemented RAID 5.
In C drive all the softwares are installed and in D there is a storage
device where all database mdf and ldf files stored now the question
is that how can I set my mdf and ldf files into different controller so the
speed would be fast?
Thanks
The easiest way is to detach the database, copy either the mdf or ldf file to
another volumn, then attach the database again.
"Rogers" wrote:

> I just want to discuss one thing with you like we have implemented RAID 5.
> In C drive all the softwares are installed and in D there is a storage
> device where all database mdf and ldf files stored now the question
> is that how can I set my mdf and ldf files into different controller so the
> speed would be fast?
> Thanks
|||I am talking about the optimzation like if I spread the log file and data
file into two different controller so the speed would be efficient.
"Jack" wrote:
[vbcol=seagreen]
> The easiest way is to detach the database, copy either the mdf or ldf file to
> another volumn, then attach the database again.
> "Rogers" wrote: