Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia Pupo
I think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll[vbcol=seagreen]
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
Sql[vbcol=seagreen]
windows
>

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia Pupo
I think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll[vbcol=seagreen]
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
Sql[vbcol=seagreen]
windows
>

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia Pupo
I think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll[vbcol=seagreen]
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
Sql[vbcol=seagreen]
windows
>

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia PupoI think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
Sql[vbcol=seagreen]
windows[vbcol=seagreen]
>

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia PupoI think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > HI
> > i have installed VisualStudio Sp6 after this installation when open my
Sql
> > 2000 server Sp3 i can't visualize Diagrams. Any operation on this
windows
> > don't work.
> > I reinstalled Sql Sp3 but don't work.
> > Can help me?
> > Tia Pupo
> >
> >
>

Developing a client server app using SQLServer - Steps

How do we go about setting a C/S application. Here are the steps.
1. Network Operating system.
2. SQL Server 2000 Installation on a Client / Server Network.
3. Install and setup Active Directory Services on a Client / Server
Network.
4. Concept of Domain Controller in a Windows Network.
5. Setup a Domain Model and Client / Server Model on a Network.
6. Secure Databases in Sql Server.
7. Setup and use Windows Authentication in Sql Server.
8. Setup and use SQL Server Authentication.
9. Create Logins in Sql Server.
10. Define Database Roles in Sql Server.
11. Define Server Roles in Sql Server.
12. Use the Enterprise Manager of Sql Server.
13. Use the Query Analyzer of Sql Server.
14. Create a Database.
15. Create a Table using SQL Script.
16. Create Primary Keys and Foreign Keys.
17. Create Indexes, Clustered and Non Clustered Indexes.
18. Establish Connection with SQL Server over a Network.
19. Create a Connection Object.
20. Create a Command Object, its Properties and Methods.
21. Create a Recordset Object in a Visual Basic ( VB ) application.
22. Access SQL Server Database using ADO.
23. Retreive Data From SQL Server Over a client server Network.
24. Create Multiple Command Objects using a Single Connection.
25. Specify a OLEDB data provider in Visual Basic ( VB ) for a client
server application.
26. Pass Connection Information to SQL Server over a network using
Visual Basic ( VB.).
27.Insert a New Record in SQL server using Visual Basic ( VB ).
28.Update and Delete a record using the Execute Method.
29.Execute a Stored Procedure using a Command Object.
30.Create a Input Parameter.
31.Create a Output Parameter.
32.Create Dynamic Recordsets, Keyset Recordsets, Static Recordsets,
Forward Only Recordsets.
33.Create Client Side Only Recordsets.
34.Assign a lock for Client Side Recordsets.
35.Navigate and Bind Controls to a Recordset.
36.Retrieve Fields of Recordsets.
37.Manually Populate Controls.
38.Add a new Record, Modify and Delete a Record.
39.Setup a DNS server.
40.Setup a DHCP Server.
41.Assign IP Address in a Client Server network.
42.Setup a Network Topology.
43.How to Create a Project.
44.How to Create a Menu.
45.SQL Server Security.
46.Standard Security Mode.
47.Setup a Integrated Security Mode.
48.Create Constants.
49.Relational Databases are used in a Client Server Accounting
application.
50.Implement relationships using Key Fields.
51.Client/Server Architecture.
52.Create a Class for developing a database application.
53.Object Oriented Programming is used in a VB/SQL Environment.
54.Use a Datagrid in a VB, Sql server accounting application.
55.Create and Use Standard Modules in a database application.
56.Design the database using SQL Server.
57.Program the Form_Load() event procedure.
58.Program the Form_Activate() event procedure.
59.Program the Cancelbutton.
60.Setup and Validate the data entered in the text box control.
61.Create and Add a Class using Visual basic ( VB ) for a client server
application.
62.How to write Property Procedures.
63.How to write Get Property Procedure.
Any questions email me. Before that you can have a look at the FAQ i
have collected and posted here http://www.vkinfotek.com/faq.html
Regards
MadhWha-a-a-a-t?
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
<pedaammulu@.yahoo.com> wrote in message
news:1151489920.428568.278820@.x69g2000cwx.googlegroups.com...
> How do we go about setting a C/S application. Here are the steps.
> 1. Network Operating system.
> 2. SQL Server 2000 Installation on a Client / Server Network.
> 3. Install and setup Active Directory Services on a Client / Server
> Network.
> 4. Concept of Domain Controller in a Windows Network.
> 5. Setup a Domain Model and Client / Server Model on a Network.
> 6. Secure Databases in Sql Server.
> 7. Setup and use Windows Authentication in Sql Server.
> 8. Setup and use SQL Server Authentication.
> 9. Create Logins in Sql Server.
> 10. Define Database Roles in Sql Server.
> 11. Define Server Roles in Sql Server.
> 12. Use the Enterprise Manager of Sql Server.
> 13. Use the Query Analyzer of Sql Server.
> 14. Create a Database.
> 15. Create a Table using SQL Script.
> 16. Create Primary Keys and Foreign Keys.
> 17. Create Indexes, Clustered and Non Clustered Indexes.
> 18. Establish Connection with SQL Server over a Network.
> 19. Create a Connection Object.
> 20. Create a Command Object, its Properties and Methods.
> 21. Create a Recordset Object in a Visual Basic ( VB ) application.
> 22. Access SQL Server Database using ADO.
> 23. Retreive Data From SQL Server Over a client server Network.
> 24. Create Multiple Command Objects using a Single Connection.
> 25. Specify a OLEDB data provider in Visual Basic ( VB ) for a client
> server application.
> 26. Pass Connection Information to SQL Server over a network using
> Visual Basic ( VB.).
> 27.Insert a New Record in SQL server using Visual Basic ( VB ).
> 28.Update and Delete a record using the Execute Method.
> 29.Execute a Stored Procedure using a Command Object.
> 30.Create a Input Parameter.
> 31.Create a Output Parameter.
> 32.Create Dynamic Recordsets, Keyset Recordsets, Static Recordsets,
> Forward Only Recordsets.
> 33.Create Client Side Only Recordsets.
> 34.Assign a lock for Client Side Recordsets.
> 35.Navigate and Bind Controls to a Recordset.
> 36.Retrieve Fields of Recordsets.
> 37.Manually Populate Controls.
> 38.Add a new Record, Modify and Delete a Record.
> 39.Setup a DNS server.
> 40.Setup a DHCP Server.
> 41.Assign IP Address in a Client Server network.
> 42.Setup a Network Topology.
> 43.How to Create a Project.
> 44.How to Create a Menu.
> 45.SQL Server Security.
> 46.Standard Security Mode.
> 47.Setup a Integrated Security Mode.
> 48.Create Constants.
> 49.Relational Databases are used in a Client Server Accounting
> application.
> 50.Implement relationships using Key Fields.
> 51.Client/Server Architecture.
> 52.Create a Class for developing a database application.
> 53.Object Oriented Programming is used in a VB/SQL Environment.
> 54.Use a Datagrid in a VB, Sql server accounting application.
> 55.Create and Use Standard Modules in a database application.
> 56.Design the database using SQL Server.
> 57.Program the Form_Load() event procedure.
> 58.Program the Form_Activate() event procedure.
> 59.Program the Cancelbutton.
> 60.Setup and Validate the data entered in the text box control.
> 61.Create and Add a Class using Visual basic ( VB ) for a client server
> application.
> 62.How to write Property Procedures.
> 63.How to write Get Property Procedure.
> Any questions email me. Before that you can have a look at the FAQ i
> have collected and posted here http://www.vkinfotek.com/faq.html
> Regards
> Madh
>

Developer installation fails - does not prompt for Disk 2!

I have tried this many times....cleaned all previous MS SQL installations...rebooted....all with the same result below.

I insert Disc 1 of the Developer edition and all is find until it gets to the main installation...then OWC fails ("Setup cannot find the files specified") although I have an open Internet connection from where it can be downloaded.

Then the main Database server and Integration services installation fails, and other components succeed. When I click the error message it says "Please insert Disc 2" - although the main installation never prompts for Disc 2 (which are the Tools I believe).

Even if I install Disc 2, the installation never succeeds - and the main componets I am interested in - Database server and Integration services - always fails.

I have used the developer edition with many operating systems OWC is not a requirement for installing it, I have to tell you installing SQL Server from CD is not good practice. You need to create a folder in your C drive and copy the contents of the CDs into that folder and your installation will complete because all your files are in one place. If you need OWC in your development environment you need to download that to the folder before running the installer. Hope this helps.

Developer edition installation error on XP Professional

When trying to specify the Service settings Domain User account during SQL
Server 2000 developer edition installation on an XP Pro (SP2) machine I get
the following error message: "The logon account cannot be validated for the
SQL Server service. Verify that the username and password entered are
correct. The logon attempt failed." I have tried a variety of accounts
(including administrator) and always get the same error message. The "Local
System account" option seems to proceed without error, but that doesn't meet
my application requirements.
Any help would be greatly appreciated, thanks.
- Daniel
Hi
XP needs to verify the account credentials with domain controller that thje
XP machine is in. It can't contact the DC, so it passes the error to SQL
Server installation.
Check your connectivity to your DC's.
Regards
Mike
"Daniel Scheidt" wrote:

> When trying to specify the Service settings Domain User account during SQL
> Server 2000 developer edition installation on an XP Pro (SP2) machine I get
> the following error message: "The logon account cannot be validated for the
> SQL Server service. Verify that the username and password entered are
> correct. The logon attempt failed." I have tried a variety of accounts
> (including administrator) and always get the same error message. The "Local
> System account" option seems to proceed without error, but that doesn't meet
> my application requirements.
> Any help would be greatly appreciated, thanks.
> - Daniel
|||Thanks Mike, my machine is a stand-alone box not connected to any DC. I'm
using the machine name in the "Domain:" field. This approach has worked fine
for me on Windows 2003 Server boxes, but I'm stuck on this XP install
- Daniel
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> XP needs to verify the account credentials with domain controller that thje
> XP machine is in. It can't contact the DC, so it passes the error to SQL
> Server installation.
> Check your connectivity to your DC's.
> Regards
> Mike
> "Daniel Scheidt" wrote:

Developer edition installation error on XP Professional

When trying to specify the Service settings Domain User account during SQL
Server 2000 developer edition installation on an XP Pro (SP2) machine I get
the following error message: "The logon account cannot be validated for the
SQL Server service. Verify that the username and password entered are
correct. The logon attempt failed." I have tried a variety of accounts
(including administrator) and always get the same error message. The "Local
System account" option seems to proceed without error, but that doesn't meet
my application requirements.
Any help would be greatly appreciated, thanks.
- DanielHi
XP needs to verify the account credentials with domain controller that thje
XP machine is in. It can't contact the DC, so it passes the error to SQL
Server installation.
Check your connectivity to your DC's.
Regards
Mike
"Daniel Scheidt" wrote:
> When trying to specify the Service settings Domain User account during SQL
> Server 2000 developer edition installation on an XP Pro (SP2) machine I get
> the following error message: "The logon account cannot be validated for the
> SQL Server service. Verify that the username and password entered are
> correct. The logon attempt failed." I have tried a variety of accounts
> (including administrator) and always get the same error message. The "Local
> System account" option seems to proceed without error, but that doesn't meet
> my application requirements.
> Any help would be greatly appreciated, thanks.
> - Daniel|||Thanks Mike, my machine is a stand-alone box not connected to any DC. I'm
using the machine name in the "Domain:" field. This approach has worked fine
for me on Windows 2003 Server boxes, but I'm stuck on this XP install
- Daniel
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> XP needs to verify the account credentials with domain controller that thje
> XP machine is in. It can't contact the DC, so it passes the error to SQL
> Server installation.
> Check your connectivity to your DC's.
> Regards
> Mike
> "Daniel Scheidt" wrote:
> > When trying to specify the Service settings Domain User account during SQL
> > Server 2000 developer edition installation on an XP Pro (SP2) machine I get
> > the following error message: "The logon account cannot be validated for the
> > SQL Server service. Verify that the username and password entered are
> > correct. The logon attempt failed." I have tried a variety of accounts
> > (including administrator) and always get the same error message. The "Local
> > System account" option seems to proceed without error, but that doesn't meet
> > my application requirements.
> >
> > Any help would be greatly appreciated, thanks.
> >
> > - Daniel

Developer edition installation error on XP Professional

When trying to specify the Service settings Domain User account during SQL
Server 2000 developer edition installation on an XP Pro (SP2) machine I get
the following error message: "The logon account cannot be validated for the
SQL Server service. Verify that the username and password entered are
correct. The logon attempt failed." I have tried a variety of accounts
(including administrator) and always get the same error message. The "Local
System account" option seems to proceed without error, but that doesn't meet
my application requirements.
Any help would be greatly appreciated, thanks.
- DanielHi
XP needs to verify the account credentials with domain controller that thje
XP machine is in. It can't contact the DC, so it passes the error to SQL
Server installation.
Check your connectivity to your DC's.
Regards
Mike
"Daniel Scheidt" wrote:

> When trying to specify the Service settings Domain User account during SQL
> Server 2000 developer edition installation on an XP Pro (SP2) machine I ge
t
> the following error message: "The logon account cannot be validated for th
e
> SQL Server service. Verify that the username and password entered are
> correct. The logon attempt failed." I have tried a variety of accounts
> (including administrator) and always get the same error message. The "Loca
l
> System account" option seems to proceed without error, but that doesn't me
et
> my application requirements.
> Any help would be greatly appreciated, thanks.
> - Daniel|||Thanks Mike, my machine is a stand-alone box not connected to any DC. I'm
using the machine name in the "Domain:" field. This approach has worked fine
for me on Windows 2003 Server boxes, but I'm stuck on this XP install
- Daniel
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> XP needs to verify the account credentials with domain controller that th
je
> XP machine is in. It can't contact the DC, so it passes the error to SQL
> Server installation.
> Check your connectivity to your DC's.
> Regards
> Mike
> "Daniel Scheidt" wrote:
>

Developer Edition Installation - Named Instance can't be opened

I am trying to install the Developer's Edition of SQL SERVER and I would lik
e to create a named instance.
The installation appears to work OK but I can't register the NAMED instance
in Enterprise Manager. The LOCAL instance is working OK and is registered in
Enterprise Manager.
Each time I try to register the NAMED instance I get the error SQL SERVER do
es not exist or access denied. ConnectionOpen(Connect()).
I see the instance existing in my SQL SERVER installation directory.
I am installing this in Windows XP
Any help is appreciated.
jimThis may be basic but are you trying to register it using the following
name:
<machinename\instancename>.
If you are and it is still failing. Look at the SQL Server errorlog form
that instance and verify that it is listening on shared memory, TCP/IP and
named pipes. If you are trying to register it on the server itself shared
memory is used by default. Trying regiistering it uisng the IP address and
port number that SQL Server is listening on.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I corrected the problem. I needed to clear my registry entries for a prior i
nstallation of INSTANCE.
thanks for your help

Developer Edition Installation - Named Instance can't be opened

I am trying to install the Developer's Edition of SQL SERVER and I would like to create a named instance.
The installation appears to work OK but I can't register the NAMED instance in Enterprise Manager. The LOCAL instance is working OK and is registered in Enterprise Manager.
Each time I try to register the NAMED instance I get the error SQL SERVER does not exist or access denied. ConnectionOpen(Connect()).
I see the instance existing in my SQL SERVER installation directory.
I am installing this in Windows XP
Any help is appreciated.
jim
This may be basic but are you trying to register it using the following
name:
<machinename\instancename>.
If you are and it is still failing. Look at the SQL Server errorlog form
that instance and verify that it is listening on shared memory, TCP/IP and
named pipes. If you are trying to register it on the server itself shared
memory is used by default. Trying regiistering it uisng the IP address and
port number that SQL Server is listening on.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I corrected the problem. I needed to clear my registry entries for a prior installation of INSTANCE.
thanks for your help

Developer Edition Installation - Named Instance can't be opened

I am trying to install the Developer's Edition of SQL SERVER and I would like to create a named instance
The installation appears to work OK but I can't register the NAMED instance in Enterprise Manager. The LOCAL instance is working OK and is registered in Enterprise Manager
Each time I try to register the NAMED instance I get the error SQL SERVER does not exist or access denied. ConnectionOpen(Connect())
I see the instance existing in my SQL SERVER installation directory.
I am installing this in Windows X
Any help is appreciated
jimDid you do an advanced install?
>--Original Message--
>I am trying to install the Developer's Edition of SQL
SERVER and I would like to create a named instance.
>The installation appears to work OK but I can't register
the NAMED instance in Enterprise Manager. The LOCAL
instance is working OK and is registered in Enterprise
Manager.
>Each time I try to register the NAMED instance I get the
error SQL SERVER does not exist or access denied.
ConnectionOpen(Connect()).
>I see the instance existing in my SQL SERVER installation
directory.
>I am installing this in Windows XP
>Any help is appreciated.
>jim
>.
>|||This may be basic but are you trying to register it using the following
name:
<machinename\instancename>.
If you are and it is still failing. Look at the SQL Server errorlog form
that instance and verify that it is listening on shared memory, TCP/IP and
named pipes. If you are trying to register it on the server itself shared
memory is used by default. Trying regiistering it uisng the IP address and
port number that SQL Server is listening on.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I corrected the problem. I needed to clear my registry entries for a prior installation of INSTANCE
thanks for your help