We've recently installed a couple of Windows Server 2003 Ent Ed servers with
SQL 2000 Ent Ed and one of the active/active nodes continually gives the
error below in the Application Event log.
The NT user which was used to install the server and owns the directories
and files below has full rights so this should not be an issue.
I've checked MSDN, etc. but nothing which seems to help.
Thanks.
Ron
17050 :
initerrlog: Could not open error log file 'D:\Program Files\Microsoft SQL
Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot find
the path specified.).
Ron,
Is drive D local to the server or on the cluster's shared drives? The error
message could be implying that the node in question was installed with the
data files on a local drive.
Hope this helps,
Ron
Ron Talmage
SQL Server MVP
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> We've recently installed a couple of Windows Server 2003 Ent Ed servers
with
> SQL 2000 Ent Ed and one of the active/active nodes continually gives the
> error below in the Application Event log.
> The NT user which was used to install the server and owns the directories
> and files below has full rights so this should not be an issue.
> I've checked MSDN, etc. but nothing which seems to help.
> Thanks.
> Ron
> --
> 17050 :
> initerrlog: Could not open error log file 'D:\Program Files\Microsoft SQL
> Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot
find
> the path specified.).
> --
|||BTW, there's a webcast on troubleshooting a SQL Server 2000 cluster install
that contains a lot of detail not available elsewhere:
http://support.microsoft.com/default...lurb020703.asp
Ron
Ron Talmage
SQL Server MVP
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23c46wJI%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> Ron,
> Is drive D local to the server or on the cluster's shared drives? The
error[vbcol=seagreen]
> message could be implying that the node in question was installed with the
> data files on a local drive.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> with
directories[vbcol=seagreen]
SQL
> find
>
|||Ron,
I'll review the webcast...thanks!
SQL Server is installed on the C: drive, the data files are installed on D:
which is a SAN drive share.
I've rebooted both nodes and only started node1...with node2 offline, there
errors are not appearing in the event logs...? Seems odd as it's node1 which
is logging the errors...any other ideas?
Thanks.
Ron
"Ron Talmage" wrote:
> BTW, there's a webcast on troubleshooting a SQL Server 2000 cluster install
> that contains a lot of detail not available elsewhere:
> http://support.microsoft.com/default...lurb020703.asp
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ron Talmage" <rtalmage@.prospice.com> wrote in message
> news:%23c46wJI%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> error
> directories
> SQL
>
>
Showing posts with label ent. Show all posts
Showing posts with label ent. Show all posts
Thursday, March 29, 2012
Cluster SQL 2000 errorlog problem
We've recently installed a couple of Windows Server 2003 Ent Ed servers with
SQL 2000 Ent Ed and one of the active/active nodes continually gives the
error below in the Application Event log.
The NT user which was used to install the server and owns the directories
and files below has full rights so this should not be an issue.
I've checked MSDN, etc. but nothing which seems to help.
Thanks.
Ron
17050 :
initerrlog: Could not open error log file 'D:\Program Files\Microsoft SQL
Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot fin
d
the path specified.).Ron,
Is drive D local to the server or on the cluster's shared drives? The error
message could be implying that the node in question was installed with the
data files on a local drive.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> We've recently installed a couple of Windows Server 2003 Ent Ed servers
with
> SQL 2000 Ent Ed and one of the active/active nodes continually gives the
> error below in the Application Event log.
> The NT user which was used to install the server and owns the directories
> and files below has full rights so this should not be an issue.
> I've checked MSDN, etc. but nothing which seems to help.
> Thanks.
> Ron
> --
> 17050 :
> initerrlog: Could not open error log file 'D:\Program Files\Microsoft SQL
> Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot
find
> the path specified.).
> --|||BTW, there's a webcast on troubleshooting a SQL Server 2000 cluster install
that contains a lot of detail not available elsewhere:
http://support.microsoft.com/defaul...blurb020703.asp
Ron
--
Ron Talmage
SQL Server MVP
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23c46wJI%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> Ron,
> Is drive D local to the server or on the cluster's shared drives? The
error
> message could be implying that the node in question was installed with the
> data files on a local drive.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> with
directories[vbcol=seagreen]
SQL[vbcol=seagreen]
> find
>|||Ron,
I'll review the webcast...thanks!
SQL Server is installed on the C: drive, the data files are installed on D:
which is a SAN drive share.
I've rebooted both nodes and only started node1...with node2 offline, there
errors are not appearing in the event logs...? Seems odd as it's node1 whic
h
is logging the errors...any other ideas?
Thanks.
Ron
"Ron Talmage" wrote:
> BTW, there's a webcast on troubleshooting a SQL Server 2000 cluster instal
l
> that contains a lot of detail not available elsewhere:
> http://support.microsoft.com/defaul...blurb020703.asp
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ron Talmage" <rtalmage@.prospice.com> wrote in message
> news:%23c46wJI%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> error
> directories
> SQL
>
>
SQL 2000 Ent Ed and one of the active/active nodes continually gives the
error below in the Application Event log.
The NT user which was used to install the server and owns the directories
and files below has full rights so this should not be an issue.
I've checked MSDN, etc. but nothing which seems to help.
Thanks.
Ron
17050 :
initerrlog: Could not open error log file 'D:\Program Files\Microsoft SQL
Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot fin
d
the path specified.).Ron,
Is drive D local to the server or on the cluster's shared drives? The error
message could be implying that the node in question was installed with the
data files on a local drive.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> We've recently installed a couple of Windows Server 2003 Ent Ed servers
with
> SQL 2000 Ent Ed and one of the active/active nodes continually gives the
> error below in the Application Event log.
> The NT user which was used to install the server and owns the directories
> and files below has full rights so this should not be an issue.
> I've checked MSDN, etc. but nothing which seems to help.
> Thanks.
> Ron
> --
> 17050 :
> initerrlog: Could not open error log file 'D:\Program Files\Microsoft SQL
> Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot
find
> the path specified.).
> --|||BTW, there's a webcast on troubleshooting a SQL Server 2000 cluster install
that contains a lot of detail not available elsewhere:
http://support.microsoft.com/defaul...blurb020703.asp
Ron
--
Ron Talmage
SQL Server MVP
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23c46wJI%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> Ron,
> Is drive D local to the server or on the cluster's shared drives? The
error
> message could be implying that the node in question was installed with the
> data files on a local drive.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> with
directories[vbcol=seagreen]
SQL[vbcol=seagreen]
> find
>|||Ron,
I'll review the webcast...thanks!
SQL Server is installed on the C: drive, the data files are installed on D:
which is a SAN drive share.
I've rebooted both nodes and only started node1...with node2 offline, there
errors are not appearing in the event logs...? Seems odd as it's node1 whic
h
is logging the errors...any other ideas?
Thanks.
Ron
"Ron Talmage" wrote:
> BTW, there's a webcast on troubleshooting a SQL Server 2000 cluster instal
l
> that contains a lot of detail not available elsewhere:
> http://support.microsoft.com/defaul...blurb020703.asp
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ron Talmage" <rtalmage@.prospice.com> wrote in message
> news:%23c46wJI%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> error
> directories
> SQL
>
>
Tuesday, March 27, 2012
Cluster SQL 2000 errorlog problem
We've recently installed a couple of Windows Server 2003 Ent Ed servers with
SQL 2000 Ent Ed and one of the active/active nodes continually gives the
error below in the Application Event log.
The NT user which was used to install the server and owns the directories
and files below has full rights so this should not be an issue.
I've checked MSDN, etc. but nothing which seems to help.
Thanks.
Ron
--
17050 :
initerrlog: Could not open error log file 'D:\Program Files\Microsoft SQL
Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot find
the path specified.).
--Ron,
Is drive D local to the server or on the cluster's shared drives? The error
message could be implying that the node in question was installed with the
data files on a local drive.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> We've recently installed a couple of Windows Server 2003 Ent Ed servers
with
> SQL 2000 Ent Ed and one of the active/active nodes continually gives the
> error below in the Application Event log.
> The NT user which was used to install the server and owns the directories
> and files below has full rights so this should not be an issue.
> I've checked MSDN, etc. but nothing which seems to help.
> Thanks.
> Ron
> --
> 17050 :
> initerrlog: Could not open error log file 'D:\Program Files\Microsoft SQL
> Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot
find
> the path specified.).
> --|||BTW, there's a webcast on troubleshooting a SQL Server 2000 cluster install
that contains a lot of detail not available elsewhere:
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wcd020703/wcdblurb020703.asp
Ron
--
Ron Talmage
SQL Server MVP
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23c46wJI%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> Ron,
> Is drive D local to the server or on the cluster's shared drives? The
error
> message could be implying that the node in question was installed with the
> data files on a local drive.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> > We've recently installed a couple of Windows Server 2003 Ent Ed servers
> with
> > SQL 2000 Ent Ed and one of the active/active nodes continually gives the
> > error below in the Application Event log.
> >
> > The NT user which was used to install the server and owns the
directories
> > and files below has full rights so this should not be an issue.
> >
> > I've checked MSDN, etc. but nothing which seems to help.
> > Thanks.
> > Ron
> >
> > --
> > 17050 :
> > initerrlog: Could not open error log file 'D:\Program Files\Microsoft
SQL
> > Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot
> find
> > the path specified.).
> >
> > --
>|||Ron,
I'll review the webcast...thanks!
SQL Server is installed on the C: drive, the data files are installed on D:
which is a SAN drive share.
I've rebooted both nodes and only started node1...with node2 offline, there
errors are not appearing in the event logs...? Seems odd as it's node1 which
is logging the errors...any other ideas?
Thanks.
Ron
"Ron Talmage" wrote:
> BTW, there's a webcast on troubleshooting a SQL Server 2000 cluster install
> that contains a lot of detail not available elsewhere:
> http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wcd020703/wcdblurb020703.asp
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ron Talmage" <rtalmage@.prospice.com> wrote in message
> news:%23c46wJI%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> > Ron,
> >
> > Is drive D local to the server or on the cluster's shared drives? The
> error
> > message could be implying that the node in question was installed with the
> > data files on a local drive.
> >
> > Hope this helps,
> > Ron
> > --
> > Ron Talmage
> > SQL Server MVP
> >
> > "Ron" <Ron@.discussions.microsoft.com> wrote in message
> > news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> > > We've recently installed a couple of Windows Server 2003 Ent Ed servers
> > with
> > > SQL 2000 Ent Ed and one of the active/active nodes continually gives the
> > > error below in the Application Event log.
> > >
> > > The NT user which was used to install the server and owns the
> directories
> > > and files below has full rights so this should not be an issue.
> > >
> > > I've checked MSDN, etc. but nothing which seems to help.
> > > Thanks.
> > > Ron
> > >
> > > --
> > > 17050 :
> > > initerrlog: Could not open error log file 'D:\Program Files\Microsoft
> SQL
> > > Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot
> > find
> > > the path specified.).
> > >
> > > --
> >
> >
>
>sqlsql
SQL 2000 Ent Ed and one of the active/active nodes continually gives the
error below in the Application Event log.
The NT user which was used to install the server and owns the directories
and files below has full rights so this should not be an issue.
I've checked MSDN, etc. but nothing which seems to help.
Thanks.
Ron
--
17050 :
initerrlog: Could not open error log file 'D:\Program Files\Microsoft SQL
Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot find
the path specified.).
--Ron,
Is drive D local to the server or on the cluster's shared drives? The error
message could be implying that the node in question was installed with the
data files on a local drive.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> We've recently installed a couple of Windows Server 2003 Ent Ed servers
with
> SQL 2000 Ent Ed and one of the active/active nodes continually gives the
> error below in the Application Event log.
> The NT user which was used to install the server and owns the directories
> and files below has full rights so this should not be an issue.
> I've checked MSDN, etc. but nothing which seems to help.
> Thanks.
> Ron
> --
> 17050 :
> initerrlog: Could not open error log file 'D:\Program Files\Microsoft SQL
> Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot
find
> the path specified.).
> --|||BTW, there's a webcast on troubleshooting a SQL Server 2000 cluster install
that contains a lot of detail not available elsewhere:
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wcd020703/wcdblurb020703.asp
Ron
--
Ron Talmage
SQL Server MVP
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23c46wJI%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> Ron,
> Is drive D local to the server or on the cluster's shared drives? The
error
> message could be implying that the node in question was installed with the
> data files on a local drive.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> > We've recently installed a couple of Windows Server 2003 Ent Ed servers
> with
> > SQL 2000 Ent Ed and one of the active/active nodes continually gives the
> > error below in the Application Event log.
> >
> > The NT user which was used to install the server and owns the
directories
> > and files below has full rights so this should not be an issue.
> >
> > I've checked MSDN, etc. but nothing which seems to help.
> > Thanks.
> > Ron
> >
> > --
> > 17050 :
> > initerrlog: Could not open error log file 'D:\Program Files\Microsoft
SQL
> > Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot
> find
> > the path specified.).
> >
> > --
>|||Ron,
I'll review the webcast...thanks!
SQL Server is installed on the C: drive, the data files are installed on D:
which is a SAN drive share.
I've rebooted both nodes and only started node1...with node2 offline, there
errors are not appearing in the event logs...? Seems odd as it's node1 which
is logging the errors...any other ideas?
Thanks.
Ron
"Ron Talmage" wrote:
> BTW, there's a webcast on troubleshooting a SQL Server 2000 cluster install
> that contains a lot of detail not available elsewhere:
> http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wcd020703/wcdblurb020703.asp
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ron Talmage" <rtalmage@.prospice.com> wrote in message
> news:%23c46wJI%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> > Ron,
> >
> > Is drive D local to the server or on the cluster's shared drives? The
> error
> > message could be implying that the node in question was installed with the
> > data files on a local drive.
> >
> > Hope this helps,
> > Ron
> > --
> > Ron Talmage
> > SQL Server MVP
> >
> > "Ron" <Ron@.discussions.microsoft.com> wrote in message
> > news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> > > We've recently installed a couple of Windows Server 2003 Ent Ed servers
> > with
> > > SQL 2000 Ent Ed and one of the active/active nodes continually gives the
> > > error below in the Application Event log.
> > >
> > > The NT user which was used to install the server and owns the
> directories
> > > and files below has full rights so this should not be an issue.
> > >
> > > I've checked MSDN, etc. but nothing which seems to help.
> > > Thanks.
> > > Ron
> > >
> > > --
> > > 17050 :
> > > initerrlog: Could not open error log file 'D:\Program Files\Microsoft
> SQL
> > > Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot
> > find
> > > the path specified.).
> > >
> > > --
> >
> >
>
>sqlsql
Monday, March 19, 2012
Cluster / SQL 2005 / SAN storage
Hi...I got some basic questions in regards to setup a lab environment
with two nodes cluster over Windows ent 2003, ent SQL 2005 and SAN
storage.
1) Would the following hardware be enough: SAN storage, fiber channel
switch, two intel servers, 4 HBA (2 for each servers) ?
2) what is the difference betwen fiber channel switch and fiber
channel routing?
3) what is different between fiber channel and iSCSI?
4) what is the zoning?
5) what is the steps to install the cluster windows server?
6) what is the steps to configure the SQL2005? do I need to install
SQL twice in each node, or I just need to install once in the vitual
server?
7) what is the draft diagram?
8) what is the private network, public network for SAN?
Thanks,
Yve
> 1) Would the following hardware be enough: SAN storage, fiber channel
> switch, two intel servers, 4 HBA (2 for each servers) ?
Best practice would be to have two FC switches to create two fabrics for
redundancy. Also as you mention 2 HBA's per node, you probably want "Multi
path software", contact your storage vendor to get more information.
> 2) what is the difference betwen fiber channel switch and fiber
> channel routing?
Switching is done within a fabric. In VERY large installations, routing
might be needed to "route" between various fabrics, most installations, even
with multiple fabrics, you would find switches only. If you only build a
cluster in a lab, you would not need routing.
> 3) what is different between fiber channel and iSCSI?
iSCSI runs over IP protocol, iSCSI is deemed to be more cost efficient,
however when building a SAN there are many questions on cost, speed,
performance, interoperability and reliability (.. .and so on).
> 4) what is the zoning?
In a Fibre Channel Fabric, Zoning determines which HBA can talk to which
port on the Storage.
(e.g. HBA-1 from Server-2 can communicate to Port-X on Storage-A) this
allows multiple Servers and multiple Storage units to be connected to a
Fabric, without "conflicting" traffic on your SAN)
> 5) what is the steps to install the cluster windows server?
Have a read of this first:
- http://technet2.microsoft.com/windowsserver/en/technologies/genclust.mspx
A good collection of cluster related articles can be found here:
- http://www.nw-america.com/
> 6) what is the steps to configure the SQL2005? do I need to install
> SQL twice in each node, or I just need to install once in the vitual
> server?
Have a read about this in the online books
> 7) what is the draft diagram?
I leave this to SQL guys to answer
> 8) what is the private network, public network for SAN?
- private network is the IP network between the Cluster Nodes for cluster
(only) communications
- public network is the IP network both nodes are connected to, and which
will be used for users to connect to your clustered SQL databases
- private/public networks have nothing to do with SAN, SAN is the network
(FC or iSCSI) which connects your nodes to the shared storage.
> Thanks,
> Yve
>
Hope this helps,
Rgds,
Edwin.
with two nodes cluster over Windows ent 2003, ent SQL 2005 and SAN
storage.
1) Would the following hardware be enough: SAN storage, fiber channel
switch, two intel servers, 4 HBA (2 for each servers) ?
2) what is the difference betwen fiber channel switch and fiber
channel routing?
3) what is different between fiber channel and iSCSI?
4) what is the zoning?
5) what is the steps to install the cluster windows server?
6) what is the steps to configure the SQL2005? do I need to install
SQL twice in each node, or I just need to install once in the vitual
server?
7) what is the draft diagram?
8) what is the private network, public network for SAN?
Thanks,
Yve
> 1) Would the following hardware be enough: SAN storage, fiber channel
> switch, two intel servers, 4 HBA (2 for each servers) ?
Best practice would be to have two FC switches to create two fabrics for
redundancy. Also as you mention 2 HBA's per node, you probably want "Multi
path software", contact your storage vendor to get more information.
> 2) what is the difference betwen fiber channel switch and fiber
> channel routing?
Switching is done within a fabric. In VERY large installations, routing
might be needed to "route" between various fabrics, most installations, even
with multiple fabrics, you would find switches only. If you only build a
cluster in a lab, you would not need routing.
> 3) what is different between fiber channel and iSCSI?
iSCSI runs over IP protocol, iSCSI is deemed to be more cost efficient,
however when building a SAN there are many questions on cost, speed,
performance, interoperability and reliability (.. .and so on).
> 4) what is the zoning?
In a Fibre Channel Fabric, Zoning determines which HBA can talk to which
port on the Storage.
(e.g. HBA-1 from Server-2 can communicate to Port-X on Storage-A) this
allows multiple Servers and multiple Storage units to be connected to a
Fabric, without "conflicting" traffic on your SAN)
> 5) what is the steps to install the cluster windows server?
Have a read of this first:
- http://technet2.microsoft.com/windowsserver/en/technologies/genclust.mspx
A good collection of cluster related articles can be found here:
- http://www.nw-america.com/
> 6) what is the steps to configure the SQL2005? do I need to install
> SQL twice in each node, or I just need to install once in the vitual
> server?
Have a read about this in the online books
> 7) what is the draft diagram?
I leave this to SQL guys to answer
> 8) what is the private network, public network for SAN?
- private network is the IP network between the Cluster Nodes for cluster
(only) communications
- public network is the IP network both nodes are connected to, and which
will be used for users to connect to your clustered SQL databases
- private/public networks have nothing to do with SAN, SAN is the network
(FC or iSCSI) which connects your nodes to the shared storage.
> Thanks,
> Yve
>
Hope this helps,
Rgds,
Edwin.
Sunday, February 12, 2012
Client can't be connected.
Hi,
I want to connect my win-XP client with win-server-2003 SQL Server.
I had done following task-
- I had installed SQL-2000 (Ent. Edition) on Win-Server 2003. And it is
successfully installed.
- In Win-S-2003 with the help of Active Directory I created domain and
created user on it.
- Client computer (Win-XP Prof.) configured with domain system. and I can
successfully login on that computer as a administrator.
- On client computer installed Sql-2000 (Ent. Edition) client tool.
- In Client Network Utility Configured my SQL Server
- In Enterprise Manager I done new registration with following configuration
-- Connect using = window authontication
-- Here I found following error : SQL Server does not exist or
access denied Connection Open(Connect())
Please help me to connect my client.
Hardik.
Hi
Can you connect to SQL Server, though EM, from the SQL Server console?
If not, is SQL Server running?
Can the client ping the SQL Server server?
Regards
Mike
"Hardik Shah" wrote:
> Hi,
> I want to connect my win-XP client with win-server-2003 SQL Server.
> I had done following task-
> - I had installed SQL-2000 (Ent. Edition) on Win-Server 2003. And it is
> successfully installed.
> - In Win-S-2003 with the help of Active Directory I created domain and
> created user on it.
> - Client computer (Win-XP Prof.) configured with domain system. and I can
> successfully login on that computer as a administrator.
> - On client computer installed Sql-2000 (Ent. Edition) client tool.
> - In Client Network Utility Configured my SQL Server
> - In Enterprise Manager I done new registration with following configuration
> -- Connect using = window authontication
> -- Here I found following error : SQL Server does not exist or
> access denied Connection Open(Connect())
> Please help me to connect my client.
>
> Hardik.
>
>
|||Hi,
Thanks for your reply.
I don't know how ping work . Please tell me how can client ping the SQL
Server
Hardik Shah
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:99ED019E-B7C0-473F-90D2-1AB2B7C059FC@.microsoft.com...[vbcol=seagreen]
> Hi
> Can you connect to SQL Server, though EM, from the SQL Server console?
> If not, is SQL Server running?
> Can the client ping the SQL Server server?
> Regards
> Mike
> "Hardik Shah" wrote:
can[vbcol=seagreen]
configuration[vbcol=seagreen]
|||Yes, I tried to ping my server it run successfully..
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:99ED019E-B7C0-473F-90D2-1AB2B7C059FC@.microsoft.com...[vbcol=seagreen]
> Hi
> Can you connect to SQL Server, though EM, from the SQL Server console?
> If not, is SQL Server running?
> Can the client ping the SQL Server server?
> Regards
> Mike
> "Hardik Shah" wrote:
can[vbcol=seagreen]
configuration[vbcol=seagreen]
I want to connect my win-XP client with win-server-2003 SQL Server.
I had done following task-
- I had installed SQL-2000 (Ent. Edition) on Win-Server 2003. And it is
successfully installed.
- In Win-S-2003 with the help of Active Directory I created domain and
created user on it.
- Client computer (Win-XP Prof.) configured with domain system. and I can
successfully login on that computer as a administrator.
- On client computer installed Sql-2000 (Ent. Edition) client tool.
- In Client Network Utility Configured my SQL Server
- In Enterprise Manager I done new registration with following configuration
-- Connect using = window authontication
-- Here I found following error : SQL Server does not exist or
access denied Connection Open(Connect())
Please help me to connect my client.
Hardik.
Hi
Can you connect to SQL Server, though EM, from the SQL Server console?
If not, is SQL Server running?
Can the client ping the SQL Server server?
Regards
Mike
"Hardik Shah" wrote:
> Hi,
> I want to connect my win-XP client with win-server-2003 SQL Server.
> I had done following task-
> - I had installed SQL-2000 (Ent. Edition) on Win-Server 2003. And it is
> successfully installed.
> - In Win-S-2003 with the help of Active Directory I created domain and
> created user on it.
> - Client computer (Win-XP Prof.) configured with domain system. and I can
> successfully login on that computer as a administrator.
> - On client computer installed Sql-2000 (Ent. Edition) client tool.
> - In Client Network Utility Configured my SQL Server
> - In Enterprise Manager I done new registration with following configuration
> -- Connect using = window authontication
> -- Here I found following error : SQL Server does not exist or
> access denied Connection Open(Connect())
> Please help me to connect my client.
>
> Hardik.
>
>
|||Hi,
Thanks for your reply.
I don't know how ping work . Please tell me how can client ping the SQL
Server
Hardik Shah
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:99ED019E-B7C0-473F-90D2-1AB2B7C059FC@.microsoft.com...[vbcol=seagreen]
> Hi
> Can you connect to SQL Server, though EM, from the SQL Server console?
> If not, is SQL Server running?
> Can the client ping the SQL Server server?
> Regards
> Mike
> "Hardik Shah" wrote:
can[vbcol=seagreen]
configuration[vbcol=seagreen]
|||Yes, I tried to ping my server it run successfully..
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:99ED019E-B7C0-473F-90D2-1AB2B7C059FC@.microsoft.com...[vbcol=seagreen]
> Hi
> Can you connect to SQL Server, though EM, from the SQL Server console?
> If not, is SQL Server running?
> Can the client ping the SQL Server server?
> Regards
> Mike
> "Hardik Shah" wrote:
can[vbcol=seagreen]
configuration[vbcol=seagreen]
Subscribe to:
Posts (Atom)