Friday, March 30, 2012

Instances of SQL Server have disappeared

Hi,

We had 5 instances of SQL Server running on one of our machines and everything looked to be working fine. Today I installed another instance for a new application and once done and rebooted the new instance didn't show in the SQL Server Enterprise Manager. At this point we decided to uninstall it. After that 4 of the existing instances have diapered as well even though they are running and responding requests from their respective applications.

I did some googling and all I could see is something related to a command called nscontrol but I couldn't find any nscontrol executable on that machine.

Does anyone have any idea what this problem could be?

Thanksnscontrol is related to SQL Notification Services. I don't think that would be part of your solution.

I'm confused why you are installing a new instance of SQL Server for each application?

In any case, are you having any better luck? If not, can you go to the Windows command prompt on the server where SQL Server is running and type in osql -L and see if your instances are all listed? Have you checked your system's event log for any clues? How about the SQL Server error log?

I know that you should be able to run up to 16 instances of SQL Server, so you are probably not hitting that limitation.

Terri|||I'm with Terri. Instead of running 5 instances of SQL Server, why not use 1? And use 5 different databases? Seems like a better solution to me. Probably less overhead too.|||Sorry for not posting sooner, someone here has experienced something similar and the solution was to reregister every instance in Enterprise Manager. We can't explain why this thing happens but looks like this is what had to be done.

With respect to using instances rather then databases, the theory here is that we try to stay away from database administration and delegate it to the groups that actually need that application and databases that is why we give different instances to different groups of people. I hope that this explains somehow our situation.|||Glad you got it sorted out.

Yes, I had done research after you had made that post and read the cases for having multiple instances on the same server. That does make sense. Just keep in mind you can't have more than 16 instances :-)

Terri|||Yes, we knew about 16 instances limit.

Thanks

'Instances' of SQL Server 2000?

Our application requires multiple instances of SQL Server 2000 in order to h
ave multiple databases, which the app clients use. Has something to do with
the name of the SQL Server instance; each instance needs to be named differe
ntly.
How does this work? Do I install SQL Server multiple times in different loca
tions, or is it simply a defined thing in SQL Server? Is there a 'per instan
ce' licensing issue, or will my one SQL Server license cover the multiple in
stances of SQL Server on on
e server system?
Thanks,
JohnI believe Standard edition is licensed per instance but Enterprise Edition
can be installed with multiple instances on a server. It's best to check
the EULA to be totally certain though. But having to buy one new copy of SE
could be worth looking at why this very odd requirement was "assumed" in the
application's design IMO.
hth
Eric
John wrote:
> Our application requires multiple instances of SQL Server 2000 in
> order to have multiple databases, which the app clients use. Has
> something to do with the name of the SQL Server instance; each
> instance needs to be named differently.
> How does this work? Do I install SQL Server multiple times in
> different locations, or is it simply a defined thing in SQL Server?
> Is there a 'per instance' licensing issue, or will my one SQL Server
> license cover the multiple instances of SQL Server on one server
> system?
> Thanks,
> John|||> Our application requires multiple instances of SQL Server 2000 in order to
have multiple databases
That's the part I don't get. Why can't the application use multiple
databases in a single instance?

> How does this work? Do I install SQL Server multiple times in different
locations
For multiple instances, yes.

> Is there a 'per instance' licensing issue
Depending on the edition of SQL Server, the licensing model you're using,
the OS, etc. You really should verify licensing compliance with a local
Microsoft rep. They can give you the legal answer as opposed to collating a
variety of opinions here.
http://www.aspfaq.com/
(Reverse address to reply.)|||It is poor design IMO, but I have to live with it. On the matter of the mult
iple instances, what is meant by 'instance'? multiple installations? multipl
e 'spawnings' of SQL Server under a parent 'SQL Server manager-like' server
process? does it end up loo
king like multiple servers systems each running a SQL Server, each with diff
erent names, data paths, etc, but actually all running on the same server sy
stem?
John
"Eric Sabine" wrote:

> I believe Standard edition is licensed per instance but Enterprise Edition
> can be installed with multiple instances on a server. It's best to check
> the EULA to be totally certain though. But having to buy one new copy of
SE
> could be worth looking at why this very odd requirement was "assumed" in t
he
> application's design IMO.
> hth
> Eric
> John wrote:
>
>|||Think of an instance of how many times you ran setup.exe through completion
of the wizard. Every instance after the default (if the default is taken
at first install) has the name of the server _and_ instance name as the name
of the sql server itself.
John wrote:[vbcol=seagreen]
> It is poor design IMO, but I have to live with it. On the matter of
> the multiple instances, what is meant by 'instance'? multiple
> installations? multiple 'spawnings' of SQL Server under a parent 'SQL
> Server manager-like' server process? does it end up looking like
> multiple servers systems each running a SQL Server, each with
> different names, data paths, etc, but actually all running on the
> same server system?
> John
> "Eric Sabine" wrote:
>

'Instances' of SQL Server 2000?

Our application requires multiple instances of SQL Server 2000 in order to have multiple databases, which the app clients use. Has something to do with the name of the SQL Server instance; each instance needs to be named differently.
How does this work? Do I install SQL Server multiple times in different locations, or is it simply a defined thing in SQL Server? Is there a 'per instance' licensing issue, or will my one SQL Server license cover the multiple instances of SQL Server on on
e server system?
Thanks,
John
I believe Standard edition is licensed per instance but Enterprise Edition
can be installed with multiple instances on a server. It's best to check
the EULA to be totally certain though. But having to buy one new copy of SE
could be worth looking at why this very odd requirement was "assumed" in the
application's design IMO.
hth
Eric
John wrote:
> Our application requires multiple instances of SQL Server 2000 in
> order to have multiple databases, which the app clients use. Has
> something to do with the name of the SQL Server instance; each
> instance needs to be named differently.
> How does this work? Do I install SQL Server multiple times in
> different locations, or is it simply a defined thing in SQL Server?
> Is there a 'per instance' licensing issue, or will my one SQL Server
> license cover the multiple instances of SQL Server on one server
> system?
> Thanks,
> John
|||> Our application requires multiple instances of SQL Server 2000 in order to
have multiple databases
That's the part I don't get. Why can't the application use multiple
databases in a single instance?

> How does this work? Do I install SQL Server multiple times in different
locations
For multiple instances, yes.

> Is there a 'per instance' licensing issue
Depending on the edition of SQL Server, the licensing model you're using,
the OS, etc. You really should verify licensing compliance with a local
Microsoft rep. They can give you the legal answer as opposed to collating a
variety of opinions here.
http://www.aspfaq.com/
(Reverse address to reply.)
|||It is poor design IMO, but I have to live with it. On the matter of the multiple instances, what is meant by 'instance'? multiple installations? multiple 'spawnings' of SQL Server under a parent 'SQL Server manager-like' server process? does it end up loo
king like multiple servers systems each running a SQL Server, each with different names, data paths, etc, but actually all running on the same server system?
John
"Eric Sabine" wrote:

> I believe Standard edition is licensed per instance but Enterprise Edition
> can be installed with multiple instances on a server. It's best to check
> the EULA to be totally certain though. But having to buy one new copy of SE
> could be worth looking at why this very odd requirement was "assumed" in the
> application's design IMO.
> hth
> Eric
> John wrote:
>
>
|||Think of an instance of how many times you ran setup.exe through completion
of the wizard. Every instance after the default (if the default is taken
at first install) has the name of the server _and_ instance name as the name
of the sql server itself.
John wrote:[vbcol=seagreen]
> It is poor design IMO, but I have to live with it. On the matter of
> the multiple instances, what is meant by 'instance'? multiple
> installations? multiple 'spawnings' of SQL Server under a parent 'SQL
> Server manager-like' server process? does it end up looking like
> multiple servers systems each running a SQL Server, each with
> different names, data paths, etc, but actually all running on the
> same server system?
> John
> "Eric Sabine" wrote:
sql

Instances of SQL

Hi,

Is it possible to install more than one instance of SQL on the same server?
I am thinking of the SQL that comes with Windows 2003 SBS (Small business)

--
Thank you
Please post onlyYes. Sql2k supports named instances.

http://msdn.microsoft.com/library/e...nstall_259u.asp

"!!bogus" <hello@.microb.com> wrote in message
news:Dwavc.95442$tb4.3789522@.news20.bellglobal.com ...
> Hi,
> Is it possible to install more than one instance of SQL on the same server?
> I am thinking of the SQL that comes with Windows 2003 SBS (Small business)
> --
> Thank you
> Please post only|||"!!bogus" <hello@.microb.com> wrote in message news:<Dwavc.95442$tb4.3789522@.news20.bellglobal.com>...
> Hi,
> Is it possible to install more than one instance of SQL on the same server?
> I am thinking of the SQL that comes with Windows 2003 SBS (Small business)

SQL2000 supports multiple instances (see Books Online), but you need
to consider the impact on the server resources - you will need to
manage CPU and memory carefully to give each instance enough to work
with, as well as leaving enough for the OS and other applications. I
don't know anything about SBS specifically, but my feeling would be
that since SBS already installs a bunch of different applications on
the same server, you probably don't want to add the complexity of
multiple MSSQL instances.

Depending on what you want to achieve, you might want to look at MSDE,
which is a free version of MSSQL with some limitations:

http://www.microsoft.com/sql/msde/

Simon

instances of MSDE

I can install instances of MSDE without any problem. But
for some reasons the password (or the instance) get
corrupted after I try to upsize a table from MS Access to
an existing database in MSDE (I'll stop doing this).
But now I have multiple instances which I would like to
clean up. Does anybody know how to uninstall them?
Thanks
Perry
Hi ,
You can use the following information to uninstall msde.
A)Remove the following registry:
1) Remove the following ID_Number from your MSDE 2.0 instance
HKEY_CLASSES_ROOT\Installer\Products\ID_Number
-- It has key value name 'ProductName' which displays the instance name.
For example, "ProductName" = Microsoft SQL Server Desktop Engine
(MYINSTANCE)
2)If you had patch applied on this MSDE 2.0 instance, you need to remove
ID_Number
for that MSDE 2.0 instance:
HKEY_CLASSES_ROOT\Installer\Patches\ID_Number
3) For MSDE 2.0 Default instance, remove
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
For MSDE 2.0 named instance, remove
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\Your_instance_name
4)If you have the following key points to MSDE 2.0 productGUID, then remove
the
InstanceComponentSet.x
For example, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\Component
SetInstanceComponentSet.x
-- For example, InstanceComponentSet.1 the has value matching the
productGUID of
sqlrun01.msi.
5)Remove :
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Uninstall\Produ
ctGUID
-- the Product GUID which refers to your MSDE 2.0 instance.
6)Remove the Sql server service key:
For MSDE 2.0 default instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSSQLServer
For MSDE 2.0 named instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSSQL$Your_Instance_Nam
e
7)Remove the Sql server agent service key:
For MSDE 2.0 default instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\SQLServerAgent
For MSDE 2.0 named instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\SQLAgent$Your_Instance_
Name
B)Remove the MSDE 2.0 instance data and program install directory:
For example, G:\Program Files\Microsoft SQL
Server\MSSQL$Your_instanceName\data
For example, G:\Program Files\Microsoft SQL
Server\MSSQL$Your_instanceName\binn
Now rerun the msde setup from the command prompt
Girish Sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.

Instances list on remote IP

Is there a way to get all the SQL Server instances with SQL SMO from a
remote computer?
I got few instances on some remote IP and
how to list them, how to pass to the function this address - could it be
done at all?
Second question:
Locally I'm using SmoApplication.EnumAvailableSqlServers, but
I've got SQLEXPRESS and MSDE SP 4, and got MYCOMPUTERNAME\SQLEXPRESS and
MYCOMPUTERNAME\MSDE2000 but if I do that:
DataTable dt = SmoApplication.EnumAvailableSqlServers(false);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
ddlSQLServerInstances.Items.Add(new
ListItem(dr["Name"].ToString(), dr["Name"].ToString()));
}
}
In my dropdownlist appears only MYCOMPUTERNAME, nothing more...
I'll be happy for any suggestions.
Thank you!!!I had the same problem and it turned out to be that the firewall is blocking
the packets. I think one needs to have UDP 1343 open outbound, but unless I
turn off the firewall I still do not get non-local server instances in the
enumeration; The data seems to be sent back on random UDP ports > 2700, (th
e
port range is not confirmed) and I'm not sure if one can specify ranges usin
g
the built-in Windows XP SP2 firewall.
If anyone has a solution for this that lets me use the same firewall and
still get the enumeration, please reply. I'm curious.
"christof" wrote:

> Is there a way to get all the SQL Server instances with SQL SMO from a
> remote computer?
> I got few instances on some remote IP and
> how to list them, how to pass to the function this address - could it be
> done at all?
> Second question:
> Locally I'm using SmoApplication.EnumAvailableSqlServers, but
> I've got SQLEXPRESS and MSDE SP 4, and got MYCOMPUTERNAME\SQLEXPRESS and
> MYCOMPUTERNAME\MSDE2000 but if I do that:
> DataTable dt = SmoApplication.EnumAvailableSqlServers(false);
> if (dt.Rows.Count > 0)
> {
> foreach (DataRow dr in dt.Rows)
> {
> ddlSQLServerInstances.Items.Add(new
> ListItem(dr["Name"].ToString(), dr["Name"].ToString()));
> }
> }
> In my dropdownlist appears only MYCOMPUTERNAME, nothing more...
> I'll be happy for any suggestions.
> Thank you!!!
>

Instances in Virtual SQL Servers

Can someone explain setting up instances in virtual SQL Servers? I know that you can have multiple virtual SQL Servers on a cluster, but does each default instance, or is it one default instance on the cluster no matter how many virtual servers you have?
Thank you.
On a cluster you get one default instance and 15 named instances OR 16 named
instances. Of course you don't have to create all the instances, these are
just maximum numbers. The number of hosts in the cluster doesn't matter
towards the instance count.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"walkman" <walkman@.discussions.microsoft.com> wrote in message
news:232E50F3-15CA-40DA-9ABA-4026EA8400B6@.microsoft.com...
> Can someone explain setting up instances in virtual SQL Servers? I know
that you can have multiple virtual SQL Servers on a cluster, but does each
default instance, or is it one default instance on the cluster no matter how
many virtual servers you have?
> Thank you.
|||Thank you. I was confused in that I thought each virtual machine would have its own default instance.
"Geoff N. Hiten" wrote:

> On a cluster you get one default instance and 15 named instances OR 16 named
> instances. Of course you don't have to create all the instances, these are
> just maximum numbers. The number of hosts in the cluster doesn't matter
> towards the instance count.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "walkman" <walkman@.discussions.microsoft.com> wrote in message
> news:232E50F3-15CA-40DA-9ABA-4026EA8400B6@.microsoft.com...
> that you can have multiple virtual SQL Servers on a cluster, but does each
> default instance, or is it one default instance on the cluster no matter how
> many virtual servers you have?
>
>
|||Each Virtual Server gets a single instance. It can be either a named
instance or a default instance, however only one such virtual server per
cluster can hold a default instance. This is because of how SQL stores the
binaries for each instance locally on each host node.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"walkman" <walkman@.discussions.microsoft.com> wrote in message
news:1C60B13E-E2CC-4001-ABD5-55665EE35419@.microsoft.com...
> Thank you. I was confused in that I thought each virtual machine would
have its own default instance.[vbcol=seagreen]
> "Geoff N. Hiten" wrote:
named[vbcol=seagreen]
are[vbcol=seagreen]
know[vbcol=seagreen]
each[vbcol=seagreen]
how[vbcol=seagreen]
|||Don't feel bad. You are not alone. This is confusing at the beginning.
Here are some additional references that you may find useful:
================================================== ====
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/SQL/techinf...vercluster.asp
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Microsoft Webcasts
Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default...lurb051001.asp
Microsoft SQL Server 2000 Virtual Server: Things You Should Know
http://support.microsoft.com/default...lurb032602.asp
Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack
http://support.microsoft.com/default...lurb061002.asp
Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
http://support.microsoft.com/default...lurb101802.asp
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
Q243218 INF: Installation Order for SQL 2000 Enterprise Edition
http://support.microsoft.com/?kbid=243218
Q260758 - INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
http://support.microsoft.com/?kbid=260758
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Instances

How to see the no of instances created for my server.

if it is sql server 2005

sqlcmd -L : it will list all the instances in the network , you can identify by machine name what all the instance in your machine

for SQL 2000

osql -L

|||yes. They give the list of sql servers in the list.
But what i want is
the instances created for my server only.|||

Launch the services console: services.msc - it should list a separate SQL Server service for each instance.

You can also check the registry: HKLM\Microsoft SQL Server\Instance Names.

Thanks
Laurentiu

sql

Instance/sqlservr.exe problem

Hi! I have SQL 2000 server with several instance. Every instance start own
sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
time, but I don't know to which instance it belongs?
regards, Tomatoma
DBCC MEMORYSTATUS on the both instances
"toma" <toma@.kolumbus.fi> wrote in message
news:ab32h.43057$8W7.25630@.reader1.news.jippii.net...
> Hi! I have SQL 2000 server with several instance. Every instance start own
> sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100%
> CPU time, but I don't know to which instance it belongs?
> regards, Toma
>|||From Task Manager, you can find the process ID of the sqlservr.exe process.
If the ProcessID column is not displayed, Go to Views -> Select Columns...
and click on PID.
In the errorlog of a SQL instance, the process ID of that instance is
reported at the beginning of the errorlog. Alternatively, you can query the
process ID of the instance with SERVERPROPERTY('ProcessID').
Linchi
"toma" wrote:

> Hi! I have SQL 2000 server with several instance. Every instance start own
> sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CP
U
> time, but I don't know to which instance it belongs?
> regards, Toma
>
>|||You can get the PID you see in Task Manager by executing the
following on an instance:
SELECT SERVERPROPERTY('ProcessID')
-Sue
On Wed, 1 Nov 2006 17:37:38 +0200, "toma" <toma@.kolumbus.fi>
wrote:

>Hi! I have SQL 2000 server with several instance. Every instance start own
>sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
>time, but I don't know to which instance it belongs?
>regards, Toma
>

Instance/sqlservr.exe problem

Hi! I have SQL 2000 server with several instance. Every instance start own
sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
time, but I don't know to which instance it belongs?
regards, Toma
toma
DBCC MEMORYSTATUS on the both instances
"toma" <toma@.kolumbus.fi> wrote in message
news:ab32h.43057$8W7.25630@.reader1.news.jippii.net ...
> Hi! I have SQL 2000 server with several instance. Every instance start own
> sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100%
> CPU time, but I don't know to which instance it belongs?
> regards, Toma
>
|||From Task Manager, you can find the process ID of the sqlservr.exe process.
If the ProcessID column is not displayed, Go to Views -> Select Columns...
and click on PID.
In the errorlog of a SQL instance, the process ID of that instance is
reported at the beginning of the errorlog. Alternatively, you can query the
process ID of the instance with SERVERPROPERTY('ProcessID').
Linchi
"toma" wrote:

> Hi! I have SQL 2000 server with several instance. Every instance start own
> sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
> time, but I don't know to which instance it belongs?
> regards, Toma
>
>
|||You can get the PID you see in Task Manager by executing the
following on an instance:
SELECT SERVERPROPERTY('ProcessID')
-Sue
On Wed, 1 Nov 2006 17:37:38 +0200, "toma" <toma@.kolumbus.fi>
wrote:

>Hi! I have SQL 2000 server with several instance. Every instance start own
>sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
>time, but I don't know to which instance it belongs?
>regards, Toma
>

Instance/sqlservr.exe problem

Hi! I have SQL 2000 server with several instance. Every instance start own
sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
time, but I don't know to which instance it belongs?
regards, Tomatoma
DBCC MEMORYSTATUS on the both instances
"toma" <toma@.kolumbus.fi> wrote in message
news:ab32h.43057$8W7.25630@.reader1.news.jippii.net...
> Hi! I have SQL 2000 server with several instance. Every instance start own
> sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100%
> CPU time, but I don't know to which instance it belongs?
> regards, Toma
>|||From Task Manager, you can find the process ID of the sqlservr.exe process.
If the ProcessID column is not displayed, Go to Views -> Select Columns...
and click on PID.
In the errorlog of a SQL instance, the process ID of that instance is
reported at the beginning of the errorlog. Alternatively, you can query the
process ID of the instance with SERVERPROPERTY('ProcessID').
Linchi
"toma" wrote:
> Hi! I have SQL 2000 server with several instance. Every instance start own
> sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
> time, but I don't know to which instance it belongs?
> regards, Toma
>
>|||You can get the PID you see in Task Manager by executing the
following on an instance:
SELECT SERVERPROPERTY('ProcessID')
-Sue
On Wed, 1 Nov 2006 17:37:38 +0200, "toma" <toma@.kolumbus.fi>
wrote:
>Hi! I have SQL 2000 server with several instance. Every instance start own
>sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
>time, but I don't know to which instance it belongs?
>regards, Toma
>

Instance wil not come online

2 out of 4 instances on my 3 node cluster wil not come online on one off
the clusternodes, unless I add an alias (which I removed after
installing sp3). The application eventlog complains about not being able
to connect to the instance. I can connect to the instance remotely, but
apparently the clusterservice can not. I can not find any differences in
the registry of files. Reinstalling sql did not help. Any ideas?
Hans
Hans de Bruin wrote:
> 2 out of 4 instances on my 3 node cluster wil not come online on one off
> the clusternodes, unless I add an alias (which I removed after
> installing sp3). The application eventlog complains about not being able
> to connect to the instance. I can connect to the instance remotely, but
> apparently the clusterservice can not. I can not find any differences in
> the registry of files. Reinstalling sql did not help. Any ideas?
>
udp 1434 isn't always responding. So when the is no entry in
hkey-local_machine\software\mssqlserverclient\..\lastco nnect on my
workstation osql wil not connect. All nodes and instances report to be
8.00.818 (sp3 + latest hotfix). accoording to netstat al de nodes are
listening to udp 0.0.0.0:1434. Could W2k3 still be blocking 1434 or is
there a problem with registering the instance with the udp thing?
Hans
|||Hans de Bruin wrote:
> Hans de Bruin wrote:
>
> udp 1434 isn't always responding. So when the is no entry in
> hkey-local_machine\software\mssqlserverclient\..\lastco nnect on my
> workstation osql wil not connect. All nodes and instances report to be
> 8.00.818 (sp3 + latest hotfix). accoording to netstat al de nodes are
> listening to udp 0.0.0.0:1434. Could W2k3 still be blocking 1434 or is
> there a problem with registering the instance with the udp thing?
>
hmm, on ether node:
clear the node of all sql instances:
clear the registry on the client.
fail over one sql instance to the node.
connect to the instance: success
fail over a second instance to the node
connect to the second instance: timout on udp 1434
clear the registry on the client.
connect to the fisrt instance again: success
move the fist instance to an other node.
connect to the fisrt second again: success
So I am only able to connect to the fist activated instance on a node
useing udp 1434. Where did I go wrong?
Hans
|||Hans,
I have seen a similar problem to yours in one of our clusters.
Can you post the errors in the eventlog.
Thanks,
PK
Message posted via http://www.sqlmonster.com
|||PK via SQLMonster.com wrote:
> Hans,
> I have seen a similar problem to yours in one of our clusters.
> Can you post the errors in the eventlog.
> Thanks,
> PK
>
It looks like this one:
http://groups.google.nl/groups?threa...GP11.phx. gbl
My instances were running without local admin rights. After I
fixed this, udp1434 was behaving normally, and I could remove the
alias on the clusternodes.
I want to run some of the instances without local admin rights so I can
give developers sysadmin rights on their instance without giving them
access to the whole system.
Hans
|||Hans de Bruin wrote:
> PK via SQLMonster.com wrote:
>
> It looks like this one:
> http://groups.google.nl/groups?threa...GP11.phx. gbl
oops try this one:
http://groups.google.nl/groups?threa...0a% 40phx.gbl

>
> My instances were running without local admin rights. After I
> fixed this, udp1434 was behaving normally, and I could remove the
> alias on the clusternodes.
> I want to run some of the instances without local admin rights so I can
> give developers sysadmin rights on their instance without giving them
> access to the whole system.
>
|||Hans de Bruin wrote:
> 2 out of 4 instances on my 3 node cluster wil not come online on one off
> the clusternodes, unless I add an alias (which I removed after
> installing sp3). The application eventlog complains about not being able
> to connect to the instance. I can connect to the instance remotely, but
> apparently the clusterservice can not. I can not find any differences in
> the registry of files. Reinstalling sql did not help. Any ideas?
>
Apparently what happens is this:
- i1 come online the node as non admin and takes hold of udp 1434
- the MSCS tries to connect to the i1 and requests for the portnumber.
- i1 looks in its own the reqistry and finds the port number.
- MSCS gets an anwser an connects. i1 is online.
- i2 tries to come online on the node as either admin or non admin.
- the MSCS tries to connect to the i2 and requests for the portnumber.
- i1 tries to looks in i2's reqistry and gets an access denied.
- MSCS does not get any anwser and makes interesing calls to wins and
dns, fails to figure out the portnumer or pipename and fails i2
- i3 tries to come online on the node as either admin or non admin.
- the MSCS tries to connect to the i3 and requests for the portnumber.
- i1 tries to looks in i3's reqistry and gets an access denied.
- MSCS does not get any anwser and makes interesing calls to wins and
dns, fails to figure out the portnumer or pipename and fails i3
...
conclussion:
When running multiple sql instances (clustered or not) sql needs to run
as an local admin or system account or you need to hack the registry
permissions to let udp 1434 work, or or you need create an alias on the
server and the clients so sqlserveragent and the clients can connect.
Hans

Instance Uniunstall problem with "Uninst.isu" file

I am attempting to uninstall an instance of SQL Server 2000. When I run the SS2000 "change/uninstall" process in "Add/Remove Programs" (Control Panel), I get an error message stating that ...

"Unable to locate the installation log file 'C:\Program Files\Microsoft SQL Server\....\Uninst.isu Uninstallation will not continue."

I have looked in the directory and the file is not there.How do I uninstall SS2000?

Hi,

I am facing the same problem in fact I have manually removed all traces of sql server 2000 in program files. It is still exisiting in add/remove programs. How to remove it from there.

Thanks,

Bharath

|||

Even I am facing the same problem.

Can anyone help us., Please...

sql

Instance Uniunstall problem with "Uninst.isu" file

I am attempting to uninstall an instance of SQL Server 2000. When I run the SS2000 "change/uninstall" process in "Add/Remove Programs" (Control Panel), I get an error message stating that ...

"Unable to locate the installation log file 'C:\Program Files\Microsoft SQL Server\....\Uninst.isu Uninstallation will not continue."

I have looked in the directory and the file is not there.How do I uninstall SS2000?

Hi,

I am facing the same problem in fact I have manually removed all traces of sql server 2000 in program files. It is still exisiting in add/remove programs. How to remove it from there.

Thanks,

Bharath

Instance Uniunstall problem with "Uninst.isu" file

I am attempting to uninstall an instance of SQL Server 2000. When I run the SS2000 "change/uninstall" process in "Add/Remove Programs" (Control Panel), I get an error message stating that ...

"Unable to locate the installation log file 'C:\Program Files\Microsoft SQL Server\....\Uninst.isu Uninstallation will not continue."

I have looked in the directory and the file is not there.How do I uninstall SS2000?

Hi,

I am facing the same problem in fact I have manually removed all traces of sql server 2000 in program files. It is still exisiting in add/remove programs. How to remove it from there.

Thanks,

Bharath

|||

Even I am facing the same problem.

Can anyone help us., Please...

Instance specified not valid

Hi,

I'm trying to install MSDE SP3 which I downloaded from MS at http://www.asp.net/msde/.
Following the instructions as best I can I unzipped the file into a Folder now called MSDE located on C: I then went to a command prompt and typed in the command given to start the install:

setup SAPWD=testsite SecurityMode=SQL

Hit enter and the installer started up and ran for a few secs and then came back with

The Instance named specified is invalid

There was no mention of including an instance name or the format for it.

Suggestions please?

Also, if I want to completly uninstall MSDE if I need to how would I do it?

Thanks,
BobWell, I had this message come up if I tried to run setup for the instance that was already on the system.

I used this setup to install msde on my machine.

setup instancename="netsdk" sapwd="your password for sa" securitymode=sql

Reason for using instance name netsdk was that it seems that SDK kit needs this instance to install pubs and nwind database.

After executing this i did not get any error messages but when I started service manager I could not see any servers listed. It took me solid two hours to come up with idea to look into error log and there it was.

2004-03-09 11:57:44.50 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2004-03-09 11:57:44.50 server Copyright (C) 1988-2002 Microsoft Corporation.
2004-03-09 11:57:44.50 server All rights reserved.
2004-03-09 11:57:44.50 server Server Process ID is 3456.
2004-03-09 11:57:44.50 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$NETSDK\LOG\ERRORLOG'.
2004-03-09 11:57:44.52 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2004-03-09 11:57:44.63 server SQL Server configured for thread mode processing.
2004-03-09 11:57:44.63 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2004-03-09 11:57:44.63 spid2 Warning ******************
2004-03-09 11:57:44.63 spid2 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-03-09 11:57:44.63 spid2 Starting up database 'master'.
2004-03-09 11:57:44.98 spid5 Starting up database 'model'.
2004-03-09 11:57:44.98 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-03-09 11:57:45.03 spid2 Server name is 'PC0491-EPITKA\NETSDK'.
2004-03-09 11:57:45.03 spid2 Skipping startup of clean database id 5
2004-03-09 11:57:45.03 spid2 Skipping startup of clean database id 6
2004-03-09 11:57:45.03 spid2 Starting up database 'msdb'.
2004-03-09 11:57:45.17 server SQL server listening on Shared Memory.
2004-03-09 11:57:45.17 server SQL Server is ready for client connections
2004-03-09 11:57:45.38 spid5 Clearing tempdb database.
2004-03-09 11:57:46.12 spid5 Starting up database 'tempdb'.
2004-03-09 11:57:46.20 spid2 Recovery complete.
2004-03-09 11:57:46.20 spid2 SQL global counter collection task is created.
2004-03-09 11:57:46.22 spid2 Warning: override, autoexec procedures skipped.
2004-03-09 11:57:56.94 spid51 Error: 15457, Severity: 0, State: 1
2004-03-09 11:57:56.94 spid51 Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install..
2004-03-09 11:57:57.08 spid51 Error: 15457, Severity: 0, State: 1
2004-03-09 11:57:57.08 spid51 Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install..
2004-03-09 11:57:57.34 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager.

There is a line that says servername, I typed it in and I was able to start service. Log should be under c:\program files\microsoft sql server\mssql${your instance name}\log.

I am very new to windows world since I worked on Unix platform for past six years, so for you gurus out there this migth be something that does not need to be explained. Anyway I hope this helps.sql

Instance rename

Is it possible to rename an instance?
I expect the answer is no , but.....
Thanks in advanceI don't think it's possible to rename an instance without reinstalling, or
at least I've never tried and never seen a technique documented.
You could, however, create an alias that points to that instance...
"Jim Campau" <Jim_Campau@.bausch.com> wrote in message
news:edPkJDYRDHA.2228@.tk2msftngp13.phx.gbl...
> Is it possible to rename an instance?
> I expect the answer is no , but.....
> Thanks in advance
>|||you have to rename the Computer to rename your SQL Server. If you are
talking about renaming a named instance of SQL Server, it's not possible.
To rename named instance of sql server:
Install new instance with the new name.
Move your databases from the old instance to the newly instance (using
backup/restore or DTS).
Uninstall the old instance.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_
afterinstall_5r8f.asp
-Vishal
"Jim Campau" <Jim_Campau@.bausch.com> wrote in message
news:edPkJDYRDHA.2228@.tk2msftngp13.phx.gbl...
> Is it possible to rename an instance?
> I expect the answer is no , but.....
> Thanks in advance
>

Instance Port

Hi,
Anybody can tell me how can I get the port number of an
instance name in SQL Server 2000.
Thanks in advance.
Javier RosasJavier,
Refer to this url.
http://support.microsoft.com/default.aspx?scid=kb;[LN];265808
- Vishal
"Javier Rosas" <jrosashe@.accival.com.mx> wrote in message
news:031401c3ae15$1303d3b0$a401280a@.phx.gbl...
> Hi,
> Anybody can tell me how can I get the port number of an
> instance name in SQL Server 2000.
> Thanks in advance.
> Javier Rosas|||The best place is the header of the errorlog for the
instance. The port that the instance listens on is
identified there along with the IP address.
You could also use the Server Network Configuration to
check the configured port. But there is a chance that it's
not the port the instance is currently using.
Linchi
>--Original Message--
>Hi,
>Anybody can tell me how can I get the port number of an
>instance name in SQL Server 2000.
>Thanks in advance.
>Javier Rosas
>.
>

instance of sql server

I am learning SQL Server 2005 and I was told to install a second instance of
SQL Server 2005 on my machine. How can I install a second instance of SQL
Server 2005 on my machine

I already installed SQL Server 2005, I guess this is my first instance. To
install a second instance, do I just run setup again?Yes, just run setup again to create a 'named' instance. Setup will ask you
for an instance name.

A computer can have up to 1 default instance (probably what you installed
initially) but many named instances. To connect to the default instance
after installation, specify only the computer name. For the named instance,
specify computer name and instance name separated by a backslash
('ComputerName\InstanceName').

--
Hope this helps.

Dan Guzman
SQL Server MVP

"David" <david_vcp@.hotmail.com> wrote in message
news:bMKdnc_BtsngZ9fZRVn-rg@.comcast.com...
>I am learning SQL Server 2005 and I was told to install a second instance
>of SQL Server 2005 on my machine. How can I install a second instance of
>SQL Server 2005 on my machine
> I already installed SQL Server 2005, I guess this is my first instance.
> To install a second instance, do I just run setup again?

Instance not showning up

Hello,
I have MSDE installed on the Win2003 server named 'server1' and it's
instance is called 'manufacturing' so it's name should be (
server1\manufacturing ). That is the only place SQL is installed on the
network. Then there are four XP SP2 workstations that connect to the
databases on
(server1\manufacturing). Three of the workstations see the
(server1\manufacturing ) when they look at available SQL instances. The
fourth system , when looking for available SQL instances, sees (server1) but
without the instance name (manufacturing).
What would cause other system to see the SQL instance fine but one system to
only see the //servername and not the last part of the instance?
Any help really appreciated!Christopher Knapp wrote:
> Hello,
> I have MSDE installed on the Win2003 server named 'server1' and it's
> instance is called 'manufacturing' so it's name should be (
> server1\manufacturing ). That is the only place SQL is installed on
> the network. Then there are four XP SP2 workstations that connect to
> the databases on
> (server1\manufacturing). Three of the workstations see the
> (server1\manufacturing ) when they look at available SQL instances.
> The fourth system , when looking for available SQL instances, sees
> (server1) but without the instance name (manufacturing).
> What would cause other system to see the SQL instance fine but one
> system to only see the //servername and not the last part of the
> instance?
> Any help really appreciated!
Can this PC connect to the server, despite no "seeing" it in whatever
utility you are using to browse for available servers?
David Gugick
Imceda Software
www.imceda.com|||Thank you for the reply!
This machine can connect to the server and onther workstation over the
network without any p roblems.
Chris

> Can this PC connect to the server, despite no "seeing" it in whatever
> utility you are using to browse for available servers?
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Christopher Knapp wrote:
> Thank you for the reply!
> This machine can connect to the server and onther workstation over the
> network without any p roblems.
> Chris
Does that mean it's working properly or is not working properly?
David Gugick
Imceda Software
www.imceda.com

Instance not showning up

Hello,
I have MSDE installed on the Win2003 server named 'server1' and it's
instance is called 'manufacturing' so it's name should be (
server1\manufacturing ). That is the only place SQL is installed on the
network. Then there are four XP SP2 workstations that connect to the
databases on
(server1\manufacturing). Three of the workstations see the
(server1\manufacturing ) when they look at available SQL instances. The
fourth system , when looking for available SQL instances, sees (server1) but
without the instance name (manufacturing).
What would cause other system to see the SQL instance fine but one system to
only see the //servername and not the last part of the instance?
Any help really appreciated!
Christopher Knapp wrote:
> Hello,
> I have MSDE installed on the Win2003 server named 'server1' and it's
> instance is called 'manufacturing' so it's name should be (
> server1\manufacturing ). That is the only place SQL is installed on
> the network. Then there are four XP SP2 workstations that connect to
> the databases on
> (server1\manufacturing). Three of the workstations see the
> (server1\manufacturing ) when they look at available SQL instances.
> The fourth system , when looking for available SQL instances, sees
> (server1) but without the instance name (manufacturing).
> What would cause other system to see the SQL instance fine but one
> system to only see the //servername and not the last part of the
> instance?
> Any help really appreciated!
Can this PC connect to the server, despite no "seeing" it in whatever
utility you are using to browse for available servers?
David Gugick
Imceda Software
www.imceda.com
|||Thank you for the reply!
This machine can connect to the server and onther workstation over the
network without any p roblems.
Chris

> Can this PC connect to the server, despite no "seeing" it in whatever
> utility you are using to browse for available servers?
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
|||Christopher Knapp wrote:
> Thank you for the reply!
> This machine can connect to the server and onther workstation over the
> network without any p roblems.
> Chris
Does that mean it's working properly or is not working properly?
David Gugick
Imceda Software
www.imceda.com
sql

Instance not showning up

Hello,
I have MSDE installed on the Win2003 server named 'server1' and it's
instance is called 'manufacturing' so it's name should be (
server1\manufacturing ). That is the only place SQL is installed on the
network. Then there are four XP SP2 workstations that connect to the
databases on
(server1\manufacturing). Three of the workstations see the
(server1\manufacturing ) when they look at available SQL instances. The
fourth system , when looking for available SQL instances, sees (server1) but
without the instance name (manufacturing).
What would cause other system to see the SQL instance fine but one system to
only see the //servername and not the last part of the instance?
Any help really appreciated!Christopher Knapp wrote:
> Hello,
> I have MSDE installed on the Win2003 server named 'server1' and it's
> instance is called 'manufacturing' so it's name should be (
> server1\manufacturing ). That is the only place SQL is installed on
> the network. Then there are four XP SP2 workstations that connect to
> the databases on
> (server1\manufacturing). Three of the workstations see the
> (server1\manufacturing ) when they look at available SQL instances.
> The fourth system , when looking for available SQL instances, sees
> (server1) but without the instance name (manufacturing).
> What would cause other system to see the SQL instance fine but one
> system to only see the //servername and not the last part of the
> instance?
> Any help really appreciated!
Can this PC connect to the server, despite no "seeing" it in whatever
utility you are using to browse for available servers?
--
David Gugick
Imceda Software
www.imceda.com|||Thank you for the reply!
This machine can connect to the server and onther workstation over the
network without any p roblems.
Chris
> Can this PC connect to the server, despite no "seeing" it in whatever
> utility you are using to browse for available servers?
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Christopher Knapp wrote:
> Thank you for the reply!
> This machine can connect to the server and onther workstation over the
> network without any p roblems.
> Chris
Does that mean it's working properly or is not working properly?
--
David Gugick
Imceda Software
www.imceda.com

Instance NetSDK

Dear
I have a question about SQL Server / MSDE. Iâ'm trying install and to configure the documentation of the .NET Framework 1.1 but I have a problem because is necessary contain a instance: â'Local\NetSDKâ' (Local is the same the principal instance) second information about details of the configuration
Iâ'm working with Microsoft SQL Server 2000 â' Personal Edition and I have listed in SQL Server Service Manager only: â'Localâ'
How I make to create the instance: â'NetSDKâ'
Your
ThankI'm not sure why that SDK needs an instance of SQL Server with that
particular name, but I'd have thought it would create the instance during
it's installation...
Anyway, to create a named instance of SQL Server, you have to install it
again & you get the chance to provide the instance name during the
installation process.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Rogério Toledo" <anonymous@.discussions.microsoft.com> wrote in message
news:B75B10E3-3740-45BC-93D5-39158618C2D1@.microsoft.com...
> Dear,
> I have a question about SQL Server / MSDE. I'm trying install and to
configure the documentation of the .NET Framework 1.1 but I have a problem
because is necessary contain a instance: "Local\NetSDK" (Local is the same
the principal instance) second information about details of the
configuration.
> I'm working with Microsoft SQL Server 2000 - Personal Edition and I have
listed in SQL Server Service Manager only: "Local".
> How I make to create the instance: "NetSDK"?
> Yours
> Thanks
>

Instance naming problems

When I try to Add New Item - Database in VS C# Express, I get "An error has occurred while establishing a conncection 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: 25 - Connection string is not valid)"

When I open the management studio, I can connect to a database named Dev, and when I try to "Browse for more" from the server selector combobox, it is the only one found. I believe "Dev" was my old MSDE name, although this is also what my "Computer Name" is set to. Unfortunetly the setup of SQL Express didn't ask me what to name my instance.

I thought maybe the SQL Server 2005 Express Toolkit installation didn't actually contain the server software, and only installed the tools, as during the installation the section where I select components only listed things like client tools and what not, with not mention of the server software.

So I thought maybe it didn't install the server, so I downloaded the server installation that is by itself, and installed it, this time I saw the check for hide advanced options, so I went through the advanced options this time. I've have been through this same setup before at work, and both times it has confused me. It seems very different from installing previous versions of SQL server.

Where I choose to create a new instance or upgrade, I choose to upgade, and it is not clear what I'm upgrading, the selector does not display instance names.

At another point it asks me about configuring it to use the Local service, local system, or network account. The documentation of how these differ is vauge. For example, the network account is described basically as "don't use this" without saying what it is.

I was accustomed to just a local account, and network account settings from previous versions, and network was always the logical choice for me to use intergrated security. I don't understand what the new catagories represent and what will be functionally different in the way I connect.

So I'm really confused, and getting back to the instance names. In the surface area configuration as well as the VS Express, it only sees the name as MSSQLSERVER

For example if I "add new connection" from database explorer and click advanced, the datasource drop down lists only ".\MSSQLSERVER"

So I'm thoroughly confused at this point and not sure what to do.

Let's see if I can help you some:

* By default, if you install the SQL Server Express engine and you do not specify the instance name the instance name would be SQLEXPRESS.

* Connect to a named instance by specifying "<Computer Name>\<Instance Name>" (without the quotes). ".\<Instance Name> will also work when connect to a local instance.

* For the service account, using Network Service or domain account without administrator rights on the local server is recommended. Network Service work best if SQL Server does not need to perform functions on the network which requires more permission than Network Service has. If this is the case, use a low-privilege domain account.

* Use SQL Server Configuration Manager to view all SQL services (instances) installed. (I am not sure if SQL 2000 instance include MSDE are shown -- if not use SQL Manager or Control Panel | Services to see if MSDE is installed)

Hope this helps,

Peter Saddow

Instance name specified is invalid

I am trying to apply the sql2kdesksp3a to a new
installation of SQL desktop. When I try and apple the SP
I recieve the error The instance name is invalid. I have
tried searching for the instance in the registry that is
reffered to on KB 311762 but I can not find any
references to the MSI file used for install. I am using a
select CD from Microsoft to install SQL Desktop. I dont
understand why this should be so hard I have not loaded
any 3rd part apps just XP and the SQL desktop and
Analysis services
no
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

Instance Name of SQL Server 2005 Standard

I'm new to SQL Server, and have just started to work through the MS Press ADO.Net 2.0 Step-by-Step book.

In the beginning of the book, at the point where the Add Connection box comes up, it says to type in the Server Name text box, (local)\SQLEXPRESS, as the book takes for granted you have SQL Express installed, and hence this is the instance name.

I have Visual Studio 2005 Professional, and SQL Server 2005 Standard installed. What would the instance of SQL Server be in this case?

Any hope would be greatly appreciated.

Unless you specifically gave it a name during setup then there is no instance name as its a default instance, hence you connect with (local)|||

when you have installed sql server standard (for that matter any edition) you will be asked whether u want to install Default Instance or Named Instance. Default instance will have the same name of your Physical Machine name and named instances will have Machinename\Nameof the instance. Just to see whether you have any instances running , just open Command window

c:\ sqlcmd -L

you will get all the instances running in the network. check howmany instance are there with your physical machine name

Madhu

|||

The default instance name for non-Express editions is MSSQLSERVER. But as already mentioned, you can use the machine name to connect if using a default instance.... or you can use MSSQLSERVER.

Thanks,

Sam Lester (MSFT)

|||

I just tried using the above as the instance of SQL Server, and while the Add Connection dialogue didn't say anything about the instance being invalid, it did give me the following error: "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: 25 - Connection string is not valid)"

I guess this is progress in a way...

Any suggestions? Do I need to re-install SQL Server? I do have a couple icons which mention SQL Server Configuration Manager, and SQL Server Management Studio, would anything there help?

Any suggestions would be appreciated...

|||Can you use SQl Server Config Manager and see if there are copies of sql server running and what their names are?|||

I have SQL Server Config Manager open now, however I'm clueless on what to do next, there really aren't many options.

On the left pane, under SQL Native Client Configuration, I see Client Protocols, and Aliases.

Under Client Protocols, the right pane shows: Shared Memory, Order 1, Enabled

TCP/IP, Order 2, Enabled

Named Pipes, Order 3, Enabled

VIA Disabled

Other than this, I really don't know what else to do...

Any help is appreciated...

|||

check whether the server is enabled for Remote Connections. Go to Surface Area Configuration tool and check it. Also check firewall is enabled on this machine. if yes excempt TCP port 1433 and UDP 1434

Madhu

|||select the services node and post back what you find|||

I have no idea how to do any of this, or where it's located...

Sorry, I've never used SQL before...

|||

From where?

Sorry, I've never used SQL before...

|||

refer this link http://support.microsoft.com/kb/914277

Madhu

|||

Euan Garden wrote:

select the services node and post back what you find

what Euan mentioned is -- GO to control pannel -- Administraive tools -- Services and see what all are the services running with the name SQLServer * and post back the names of the services running on the machine

Madhu

|||

There are many services listed on two tabs, standard and extended.

However, there is nothing listed that begins with SQL.

I have no idea what to do from here, sorry..

|||

if there is no services running with name like SQL Server (MSSQLSERVER) or SQLServer (SQLExpress) etc etc.. then you have only installed client tool. In this physical machine there is no Database Engine installed. Either re-install the sql server and choose what all are the services you need or connect to any other machine which already have sql server

Madhu

sql

Instance Name Not Visible.

I have laptops that require the loopback adapter when they are not
connected. However when they connect back to the network the networked
servers display just the computer name not the / instancename. Any
ideas? It only happens on network instances. The local instances are
correct. This happens in Enterprise Manager, Access connection tool
and using SQL-DMO.
Gary Shane Lim
hi Gary,
Shane Lim wrote:
> I have laptops that require the loopback adapter when they are not
> connected. However when they connect back to the network the networked
> servers display just the computer name not the / instancename. Any
> ideas? It only happens on network instances. The local instances are
> correct. This happens in Enterprise Manager, Access connection tool
> and using SQL-DMO.
> Gary Shane Lim
are the laptops instances "named instances" or "default instances"?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||They are all names instances.
On Fri, 18 Mar 2005 11:57:13 +0100, "Andrea Montanari"
<andrea.sqlDMO@.virgilio.it> wrote:

>hi Gary,
>Shane Lim wrote:
>are the laptops instances "named instances" or "default instances"?

Instance name contains a dash

Hello

We are in the process of upgrading our SQL 2K server to a cluster environment. Currently the server is setup as a default instance running on a single box with log shipping as a warm backup

It is required to create an instance name for the new cluster to work. My question is

1) Has anybody tried to have an instance name that dash (-) in it.

Example: \\SERVERNAME\xxx-xx-xxx

I am told that it is not possible to have a server instance named this way. Would like to know if this naming convention is possible under SQL2K If not what is the suggested workaround

This will save a lot of time in application modifications

Thanks in advance

Gabe J

Don't do it, invest the work now and you will have a much more relaxing future. If it takes much time to modify your application to work with another instance name you probably have a design issue in your application.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks for the advice.

SQL 2000 books online does not specifically mention that dash (-) cannot be used in an instance name ( you can even create tables and other objects in a database that contains a dash in them why not instance name?). Could you please be a little more specific as what exactly the issues would be if the instance name contained dashes.

I have to justify the requirement to make program changes, for that I need to understand what the issues are going to be.

Appreciate your help

Gabe J

|||

I don′t have any specific issue in mind that I can tell of if you use special characters in instance names. Sure you can have special characters in Tables and other objects, but "What you can do" is often the opposite "What is prefered to do". As from my experience I wouldn′t bet on that horse and take the risk of naming the object or even the instance with special characters, although I can. Thats just my two cents, perhaps someone has another opinion about that, but unless you have a hand on your code and have the opportunity to correct that thing (as of my opinion) I would that effort in it.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

In general I agree with what Jens has to say. As far as I know, putting a dash in the instance name is supported. I remember back in the 7.0 days testers went to a lot of trouble to make sure that dashes worked fine in the server name. I don't remember finding any issues there (but it was a long time ago). I do seem to remember that our automation at the time needed multiple changes to run on those servers. :(

The effort was worth it for Microsoft but might not be for your arbitrary application.

|||

One of the suggestions made to get around with this issue is to place a registry hack by adding a key called "Connectto" in the following node

HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\MSSQLServer\Client\

And specify the value as the OLD server name = "XXX-XX-XXX"

and data = DBNMPNTW,\\<New Server name>\pipe\MSSQL$<Instance name>\sql\query

When applications connect irrespective of the connection string, this registry value connects to the SQL server instance.

Seems to work . Agree this is just a workaround instead of solving the real issue of making application modifications.

Has anyone tried this ?

Thanks for you suggestions

|||

Not sure where you heard about this registry hack, but I would not recommend using it unless it was mentioned in a specific Microsoft article...This ***hack*** may not work after a future release. Looks like this workaround maybe setting up a alias for the server. If this is the case, you should use SQL Server Configuration Manager instead.

As others have said, I am not really sure if dashes are supported, but I would not use...SQL Server maybe able to handle it fine, but some other external component may not.

Thanks,

Peter Saddow

|||

Agree that this is a **hack**. The SQL Server is a 2K version not 2005. How do I use the configuration manager to set up and alias name for the instance at the server level?

Thanks

|||

For SQL Server 2000, use SQL Server Client Network Utility. Select the "Alias" tab and enter the required information.

Hope this helps,

Peter Saddow

Instance name already exists

Hello all...
Win2k3 enterprise
SQL 2000
2 nodes
I had 2 instances of SQL installed. I had to run setup to remove clustered
SQL so I could break the disk array and make it larger.
Now, I install instance 1 on node 1 just fine.
But when I run setup on node 2 to install instance 2, it tells me that
instance name already exists.
I thought when I "un-clustered" SQL that both instances would have been
removed. I can see both instance names in C:\program files\Microsoft sql
server\
How do I go about getting rid of the second instance name now, so I can
reinstall it?
Thanks in advance.
Jeff
Hi Jeff,
I would first try to uninstall the second instance the regular way i.e using the setup CD and choosing uninstall (the same way you uninstalled the first instance). If this doesn't work then you will need to manually uninstall
it. For more info, review
HOW TO: Manually Remove SQL Server 2000 Default, Named, or Virtual Instance
http://support.microsoft.com/?kbid=290991
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Thank you Uttam,
I had tried the setup cd and it does not recognize the instance for
uninstall (only when I go to install the instance...go figure). But I did
not find the article you mention, so I will try that.
Jeff
"Uttam Parui[MS]" <uttamkp@.online.microsoft.com> wrote in message
news:RaXEsKppEHA.752@.cpmsftngxa06.phx.gbl...
> Hi Jeff,
> I would first try to uninstall the second instance the regular way i.e
using the setup CD and choosing uninstall (the same way you uninstalled the
first instance). If this doesn't work then you will need to manually
uninstall
> it. For more info, review
> HOW TO: Manually Remove SQL Server 2000 Default, Named, or Virtual
Instance
> http://support.microsoft.com/?kbid=290991
> HTH,
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>

instance name

Hello,
This is the present setup.
Server A --> sql server 2000
Server B --> sql server 2005

On my machine I point to an instance name of sql server 2000 to use. i.e.
sqlserver2000Server\instance1
On my local machine I have installed sql server 2000 and can use the enterprise manager. Have the Admin rights.
I have setup a daily backup job on sql 2000...

On server B, I installed sql 2005. Restored the sql 2000 backup onto sql 2005. And now I have the sql 2000 database in sql server 2005.

Now I can use the sql 2005 by refering to the serverB name (Not an instance).

In Server A, the applications are using a login name (sql authentication) i.e. username, password.

Questions
1) How do I install sql 2005 on my local machine (Remember that I have sql 2000)

2) If I should run the setup for sql 2005 on local machine, then during the installation, do I give it an instance name or should this instance name be done on the server i.e. server B ?

Thanks


1) How do I install sql 2005 on my local machine (Remember that I have sql 2000)

SQL Server 2000 and SQL Server 2005 can be installed side by side successfully on the same machine. You just need to run setup to install SQL Server 2005.

2) If I should run the setup for sql 2005 on local machine, then during the installation, do I give it an instance name or should this instance name be done on the server i.e. server B ?

Based on your scenario, I assume you install both SQL Server 2000 and 2005 as non-cluster installation. The instance name for SQL Server 2000 and 2005 should be unique on the same machine. So the instance names may be the same on different mahcines. But when we connect to an instance, we use machinename\instancename to specify which one to connect.

instance name

Hi,
my machine name is webdev5
when I run sql server, it asks for the server name, I enter 'webdev5'
and using windows authentication.
where can I find out about the instance name? on my machine? I am using
2005
thank you
kenInstance name is most commonly used when there are multiple installations of
SQL Server on the same computer. If you have only one SQL Server, and if you
did not deselect the "Use DEFAULT Instance" option when installing, then
your instance is named 'webdev5'.
Read about Instance and Instance Names in Books Online.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<SQLken@.gmail.com> wrote in message
news:1159221843.315654.187670@.m7g2000cwm.googlegroups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
> where can I find out about the instance name? on my machine? I am using
> 2005
> thank you
> ken
>|||Hi,
If you are logged into SQL Server Management studio then connect to SQL
server and open a Query window and execute
SELECT @.@.SERVERNAME
If its a default instance it just returns the machine name. This will be
trated as the SQL Server name. If you have Servername\Instancename;
then you have installed a named SQL Server instance.
You could also get this information from Errorlog of SQL Server. There you
have to look for Server name:.............
Thanks
Hari
SQL Server MVP
<SQLken@.gmail.com> wrote in message
news:1159221843.315654.187670@.m7g2000cwm.googlegroups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
> where can I find out about the instance name? on my machine? I am using
> 2005
> thank you
> ken
>sql

Instance name

I have two machines install SQL Server 2000.
One has the same name as my machine name, eg. alan.
Another machine has the name as 'Local'.
Why is that the case ?Alan
> Another machine has the name as 'Local'.
> Why is that the case ?
A person, who installed SQL Server specified LOCAL as name of the SQL Server
If you want to change the name ,just delete the registration from EM and
create a new one with name of the machine
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>I have two machines install SQL Server 2000.
> One has the same name as my machine name, eg. alan.
> Another machine has the name as 'Local'.
> Why is that the case ?
>|||How do I create a new one with name of the machine when setup ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
> Alan
> A person, who installed SQL Server specified LOCAL as name of the SQL
> Server
> If you want to change the name ,just delete the registration from EM and
> create a new one with name of the machine
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>|||Hi,
I really don't understand why I installed SQL Server 2000 on 2 machines, one
in my office, one at home, why one has the machine name, eg. "alan", at my
office. But on my home machine, the server instance is called "LOCAL"?
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eixndxxoGHA.1600@.TK2MSFTNGP04.phx.gbl...
> How do I create a new one with name of the machine when setup ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
>

instance name

Hi,

I just install msde SQL2kdesksp3.exe and also WebMatrix.To use WebMatrix and manage database, i need something like: myservername\instancename to connect but how do i know my instance name ?i found, i needed to reboot. actually i can connect with my SERVERNAME but can i use my IP address instead SERVERNAME cause i would like to connect remotly. MSDE and Webmatrix are installed in my Windows 2003 Server and i would like to connect that database remotly.

Is it possible ?|||fixed

instance name

Hi,
my machine name is webdev5
when I run sql server, it asks for the server name, I enter 'webdev5'
and using windows authentication.
where can I find out about the instance name? on my machine? I am using
2005
thank you
ken
Instance name is most commonly used when there are multiple installations of
SQL Server on the same computer. If you have only one SQL Server, and if you
did not deselect the "Use DEFAULT Instance" option when installing, then
your instance is named 'webdev5'.
Read about Instance and Instance Names in Books Online.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<SQLken@.gmail.com> wrote in message
news:1159221843.315654.187670@.m7g2000cwm.googlegro ups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
> where can I find out about the instance name? on my machine? I am using
> 2005
> thank you
> ken
>
|||Hi,
If you are logged into SQL Server Management studio then connect to SQL
server and open a Query window and execute
SELECT @.@.SERVERNAME
If its a default instance it just returns the machine name. This will be
trated as the SQL Server name. If you have Servername\Instancename;
then you have installed a named SQL Server instance.
You could also get this information from Errorlog of SQL Server. There you
have to look for Server name:.............
Thanks
Hari
SQL Server MVP
<SQLken@.gmail.com> wrote in message
news:1159221843.315654.187670@.m7g2000cwm.googlegro ups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
> where can I find out about the instance name? on my machine? I am using
> 2005
> thank you
> ken
>

Instance name

I have two machines install SQL Server 2000.
One has the same name as my machine name, eg. alan.
Another machine has the name as 'Local'.
Why is that the case ?Alan
> Another machine has the name as 'Local'.
> Why is that the case ?
A person, who installed SQL Server specified LOCAL as name of the SQL Server
If you want to change the name ,just delete the registration from EM and
create a new one with name of the machine
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>I have two machines install SQL Server 2000.
> One has the same name as my machine name, eg. alan.
> Another machine has the name as 'Local'.
> Why is that the case ?
>|||How do I create a new one with name of the machine when setup ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
> Alan
>> Another machine has the name as 'Local'.
>> Why is that the case ?
> A person, who installed SQL Server specified LOCAL as name of the SQL
> Server
> If you want to change the name ,just delete the registration from EM and
> create a new one with name of the machine
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>>I have two machines install SQL Server 2000.
>> One has the same name as my machine name, eg. alan.
>> Another machine has the name as 'Local'.
>> Why is that the case ?
>|||Hi,
I really don't understand why I installed SQL Server 2000 on 2 machines, one
in my office, one at home, why one has the machine name, eg. "alan", at my
office. But on my home machine, the server instance is called "LOCAL"?
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eixndxxoGHA.1600@.TK2MSFTNGP04.phx.gbl...
> How do I create a new one with name of the machine when setup ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
>> Alan
>> Another machine has the name as 'Local'.
>> Why is that the case ?
>> A person, who installed SQL Server specified LOCAL as name of the SQL
>> Server
>> If you want to change the name ,just delete the registration from EM and
>> create a new one with name of the machine
>>
>> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
>> news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>>I have two machines install SQL Server 2000.
>> One has the same name as my machine name, eg. alan.
>> Another machine has the name as 'Local'.
>> Why is that the case ?
>>
>

instance name

Hi,
my machine name is webdev5
when I run sql server, it asks for the server name, I enter 'webdev5'
and using windows authentication.
where can I find out about the instance name? on my machine? I am using
2005
thank you
kenInstance name is most commonly used when there are multiple installations of
SQL Server on the same computer. If you have only one SQL Server, and if you
did not deselect the "Use DEFAULT Instance" option when installing, then
your instance is named 'webdev5'.
Read about Instance and Instance Names in Books Online.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<SQLken@.gmail.com> wrote in message
news:1159221843.315654.187670@.m7g2000cwm.googlegroups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
> where can I find out about the instance name? on my machine? I am using
> 2005
> thank you
> ken
>|||Hi,
If you are logged into SQL Server Management studio then connect to SQL
server and open a Query window and execute
SELECT @.@.SERVERNAME
If its a default instance it just returns the machine name. This will be
trated as the SQL Server name. If you have Servername\Instancename;
then you have installed a named SQL Server instance.
You could also get this information from Errorlog of SQL Server. There you
have to look for Server name:.............
Thanks
Hari
SQL Server MVP
<SQLken@.gmail.com> wrote in message
news:1159221843.315654.187670@.m7g2000cwm.googlegroups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
> where can I find out about the instance name? on my machine? I am using
> 2005
> thank you
> ken
>sql

Instance means...

In oracle The simplest description of instance : combination of memory and process architecture

I sql server, what is the Instance.? it is combination of memory and process architecture if yes then pls give name those processes ?

A combination of menory and process architecture evidenced by a completely unique 'instance' of SQL Server. A computer can contain multiple SQL Server Instances, each with its own databases, security, users.|||

you can install sql server services more than one occurence (instance) in a same physical machine. If you install many sql server services on a single machine, you said to have many instance of sql server. One instance can be Default instance(which will have physical machine name as instance name) and all other instance can be called as Named Instances. Each instance run in different process and memory are and listen to different port. There are sql server serices which is instance instance aware and instance unaware.

eg. Database engine service is INstance aware where as SSIS is not (SSIS is common service for all instances)

Madhu

Instance Licencing

Hi,

We are have a 5 user licenced microsoft sql server 2000 cd. We need to
set this up to run two instances of the server, as we need different
setups on both databases. Does anyone know if with one cd you can do
this, so that the user licences installed are shared between the two
instances? Also do you need a aeperate server licence per instance or
if using the user license model we can install both instances from the
same cd.

Thanks for your help & time

DavidDavid wrote:

Quote:

Originally Posted by

Hi,
>
We are have a 5 user licenced microsoft sql server 2000 cd. We need to
set this up to run two instances of the server, as we need different
setups on both databases. Does anyone know if with one cd you can do
this, so that the user licences installed are shared between the two
instances? Also do you need a aeperate server licence per instance or
if using the user license model we can install both instances from the
same cd.
>
Thanks for your help & time
>
David


It's my understanding that with Enterprise version you can install
multiple instances per server but with Standard you can't (or you're
not supposed to). I'm pretty sure you would be able to use the same CD
to do so.

instance is invalid

Error message during install:
Instance is invalid.
Just installed SP3a sql2kdesksp3.exe
Hi,
I think there is a instance conflicts. THis occurs if an instance of SQL
Server is already
installed on the target machine. To overcome this issue, you have to specify
the Instance name while running the setup.
Setup.exe INSTANCENAME=<name> SAPWD=<sapassword > /l*v c:\log.txt
Create a verbose log usinfg /l*v so that you can determine if installation
was successful or not.
Thanks
Hari
MCDBA
"hangman" <hangman@.discussions.microsoft.com> wrote in message
news:C0E83B1E-95A6-4016-8D04-D5DA1A0B3765@.microsoft.com...
> Error message during install:
> Instance is invalid.
> Just installed SP3a sql2kdesksp3.exe

Instance Failure: SqlDataSource

I'm trying to populate a DropDownList with data from an SQL table (called StrataPlans). I'm getting an instance failure from the following code:

<

asp:SqlDataSourceID="dataSource"runat="server"ConnectionString="Server=BEN-TOSH\\SQLEXPRESS; TRUSTED_CONNECTION=YES; database=OSMSQL"SelectCommand="SELECT * FROM StrataPlans"ProviderName="System.Data.SqlClient"SelectCommandType="Text"/>

<asp:DropDownListID="spList"DataSourceID="dataSource"runat="server"/>

I've tested the connectionstring/select query in another of my applications and it works ok...can anyone point me in the right direction as to how to resolve this?

Thanks

Hmm,

That seems odd; an instance failure would be with creating the obect I would think. Could you provide the details of the error message?

Instance failure.

why I am getting (Instance failure.) when trying to connect to sql server from the web.config connectionstring..

the web.config entry is :

<connectionStrings>

<addname="website_connectionstring"connectionString="Data Source=.\\SQLEXPRESS;initial catalog=zatoor;integrated security=true"providerName="System.Data.SqlClient" />

<!--

<remove name="website_connectionstring"/>

<add name="website_connectionstring" connectionString="Server=whsql-v21.prod.mesa1.secureserver.net;Database=DB_143379;User ID=zatoor;Password=Mujtaba2007;Trusted_Connection=False" providerName="System.Data.SqlClient" />

-->

</connectionStrings>

the code is :

sql_connection =newSqlConnection(ConfigurationManager.ConnectionStrings["website_connectionstring"].ToString());

sql_connection.Open();

It looks you have provided wrong data source .. to confirm this login to sql management studio and check it should be

YouMachineName\SQLEXPRESS confirm the same and update the connectionString

This will solve the problem

Satya

sql

Instance confusion

I have built an application in web developer that has a sql data base in the App_Data

folder. It works locally fine.

I have uploaded it to my web host client successfully and it all displays. The web host is enabled

for asp.net. But the sql data base is not working...no information is getting from the web application into

my instance of sql in App_Data.

My web host has given me an e:/webs/mywebsitename.com/data/nameofdb.mdf

to alter in my web config connection string which I have done, but still not working.

I have also tried every version of this in connection string without success

Im just confused about the e: part............how is that going to get to my App_Data?

Can someone give me a quick overview of what the problem might be

richard

repling to myself now.....this is the holy grail

http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx

Smile

Instance caching without default parameter values

I am working with a well-studied DBA who claims that all report parameters
must have default values in order to configure instance caching. Is there
any truth to this? I don't see anything of this kind in BOL.
We actually get rsProcessAborted errors if they don't have defaults (even
though reports only execute when all parameters are provided.)
--
Paul Turley, MCSD, MCDBA, MSF, MCT
nospam at scout-master.comThis might help someone figure it out. It looks like a Reporting Services
issue to me...I'm the DBA ;)
----
--
Start snippet from Report_Server.log
----
--
aspnet_wp!processing!eec!4/26/2005-16:51:08:: e ERROR: An exception has
occurred in data source 'AGG'. Details: System.IndexOutOfRangeException:
Index was outside the bounds of the array.
at
Microsoft.ReportingServices.Library.IndexedStreamHeader.get_LastUncompressed
Offset()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.get_Interna
lUncompressedLength()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.FillBuffer(
)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream..ctor(Strea
m store)
at
Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStr
eam(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName,
Int32 chunkType, String& mimeType)
at
Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String
name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.ReportProcessing.b..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.g..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.aw.c()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.aw.b()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)
aspnet_wp!processing!d20!4/26/2005-16:51:08:: e ERROR: An exception has
occurred in data source 'AGG2'. Details: System.IndexOutOfRangeException:
Index was outside the bounds of the array.
at
Microsoft.ReportingServices.Library.IndexedStreamHeader.get_LastUncompressed
Offset()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.get_Interna
lUncompressedLength()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.FillBuffer(
)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream..ctor(Strea
m store)
at
Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStr
eam(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName,
Int32 chunkType, String& mimeType)
at
Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String
name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.ReportProcessing.b..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.g..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.aw.c()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.aw.b()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)
aspnet_wp!processing!eec!4/26/2005-16:51:08:: e ERROR: An exception has
occurred. Trying to abort processing. Details:
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at
Microsoft.ReportingServices.Library.IndexedStreamHeader.get_LastUncompressed
Offset()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.get_Interna
lUncompressedLength()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.FillBuffer(
)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream..ctor(Strea
m store)
at
Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStr
eam(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName,
Int32 chunkType, String& mimeType)
at
Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String
name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.ReportProcessing.b..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.g..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.aw.c()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.aw.b()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)
aspnet_wp!processing!d20!4/26/2005-16:51:08:: e ERROR: An exception has
occurred. Trying to abort processing. Details:
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at
Microsoft.ReportingServices.Library.IndexedStreamHeader.get_LastUncompressed
Offset()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.get_Interna
lUncompressedLength()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.FillBuffer(
)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream..ctor(Strea
m store)
at
Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStr
eam(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName,
Int32 chunkType, String& mimeType)
at
Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String
name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.ReportProcessing.b..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.g..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.aw.c()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.aw.b()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)
aspnet_wp!processing!eec!4/26/2005-16:51:08:: i INFO: Merge abort handler
called. Aborting data sources ...
aspnet_wp!processing!eec!4/26/2005-16:51:08:: i INFO: Data source
'Staging_xxxxxx_Reader': Abort handler called. CanAbort = True.
aspnet_wp!processing!d20!4/26/2005-16:51:08:: i INFO: Some other thread is
aborting processing.
aspnet_wp!processing!eec!4/26/2005-16:51:08:: i INFO: Abort callback
successful.
aspnet_wp!processing!d20!4/26/2005-16:51:08:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at
Microsoft.ReportingServices.Library.IndexedStreamHeader.get_LastUncompressed
Offset()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.get_Interna
lUncompressedLength()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.FillBuffer(
)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream..ctor(Strea
m store)
at
Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStr
eam(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName,
Int32 chunkType, String& mimeType)
at
Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String
name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.ReportProcessing.b..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.g..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.aw.c()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.aw.b()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)
-- End of inner exception stack trace --
aspnet_wp!processing!d20!4/26/2005-16:51:08:: e ERROR: Data source
'Staging_xxxxxx_Reader': An error has occurred. Details:
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
System.IndexOutOfRangeException: Index was outside the bounds of the array.
aspnet_wp!processing!d20!4/26/2005-16:51:08:: w WARN: Data source
'Staging_xxxxxx_Reader': Report processing has been aborted.
aspnet_wp!processing!d20!4/26/2005-16:51:08:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at
Microsoft.ReportingServices.Library.IndexedStreamHeader.get_LastUncompressed
Offset()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.get_Interna
lUncompressedLength()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.FillBuffer(
)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream..ctor(Strea
m store)
at
Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStr
eam(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName,
Int32 chunkType, String& mimeType)
at
Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String
name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.ReportProcessing.b..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.g..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.aw.c()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.aw.b()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)
-- End of inner exception stack trace --
aspnet_wp!library!d20!04/26/2005-16:51:08:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!d20!04/26/2005-16:51:08:: e ERROR: Reporting Services
error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An
error has occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
System.IndexOutOfRangeException: Index was outside the bounds of the array.
----
--
End snippet from Report_Server.log
----
--
-- HTH
Regards,
Don R. Watters
Walt Disney Internet Group
"Paul Turley" <nospam@.turleyfamily_dot_org> wrote in message
news:ONjOkApSFHA.3184@.TK2MSFTNGP14.phx.gbl...
> I am working with a well-studied DBA who claims that all report parameters
> must have default values in order to configure instance caching. Is there
> any truth to this? I don't see anything of this kind in BOL.
> We actually get rsProcessAborted errors if they don't have defaults (even
> though reports only execute when all parameters are provided.)
> --
> Paul Turley, MCSD, MCDBA, MSF, MCT
> nospam at scout-master.com
>|||As for the first part, no, the cache is based on a combination of report,
credentials, and parameter values. As for the second one, I don't know what
specific error you are getting.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul Turley" <nospam@.turleyfamily_dot_org> wrote in message
news:ONjOkApSFHA.3184@.TK2MSFTNGP14.phx.gbl...
>I am working with a well-studied DBA who claims that all report parameters
>must have default values in order to configure instance caching. Is there
>any truth to this? I don't see anything of this kind in BOL.
> We actually get rsProcessAborted errors if they don't have defaults (even
> though reports only execute when all parameters are provided.)
> --
> Paul Turley, MCSD, MCDBA, MSF, MCT
> nospam at scout-master.com
>|||The specific error is in my other post, on Paul's main thread.
-- Don
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%235mdZw6SFHA.616@.TK2MSFTNGP12.phx.gbl...
> As for the first part, no, the cache is based on a combination of report,
> credentials, and parameter values. As for the second one, I don't know
what
> specific error you are getting.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Paul Turley" <nospam@.turleyfamily_dot_org> wrote in message
> news:ONjOkApSFHA.3184@.TK2MSFTNGP14.phx.gbl...
> >I am working with a well-studied DBA who claims that all report
parameters
> >must have default values in order to configure instance caching. Is
there
> >any truth to this? I don't see anything of this kind in BOL.
> >
> > We actually get rsProcessAborted errors if they don't have defaults
(even
> > though reports only execute when all parameters are provided.)
> >
> > --
> > Paul Turley, MCSD, MCDBA, MSF, MCT
> > nospam at scout-master.com
> >
>|||Try refreshing your dataset and deleting and readding the dataset to your
table.
"Paul Turley" wrote:
> I am working with a well-studied DBA who claims that all report parameters
> must have default values in order to configure instance caching. Is there
> any truth to this? I don't see anything of this kind in BOL.
> We actually get rsProcessAborted errors if they don't have defaults (even
> though reports only execute when all parameters are provided.)
> --
> Paul Turley, MCSD, MCDBA, MSF, MCT
> nospam at scout-master.com
>
>