We have two sql cluster nodes that works fine till lastweek. i can still move
the cluster goup manualy from the one node to the other. the problem is i
can't move the sqlgroup manualy to the other node. When i do that the sql
manager hangs and nothing happends till i reboot the node where the cluster
group is active than become the group active on the second node. The cluster
dont log anything in the event viewer or the clusterlog file that i cab use
to find the cause of this problem.
I need some help to solve this problem.
Thanks
From the context, by "cluster manager" and "sql manager", I take that you
meant "Cluster Administrator", and Cluster Administrator still reports the
state of the cluster properly, right? (e.g. you can view whether a group is
online and on which node the group is running, etc) In addition, the SQL
instance itself works fine, right?
I'd try to establish whether this is a Cluster Administrator tool problem or
the cluster/sql problem. Try tto move the SQL group using Cluster
Administrator on one of the nodes itself. Failing that, check to see whether
the cluster service works properly w.r.t. the SQL group. For instance, you
can deny the cluster service account access to the SQL instance, and this
will force the cluster service to bounce the SQL group between the nodes
(because its IsAlive check would fail) and eventually give up. If the cluster
does behave this way, I'd then focus on troubleshooting the Cluster
Adminitrator itself.
Linchi
"Saber" wrote:
> We have two sql cluster nodes that works fine till lastweek. i can still move
> the cluster goup manualy from the one node to the other. the problem is i
> can't move the sqlgroup manualy to the other node. When i do that the sql
> manager hangs and nothing happends till i reboot the node where the cluster
> group is active than become the group active on the second node. The cluster
> dont log anything in the event viewer or the clusterlog file that i cab use
> to find the cause of this problem.
> I need some help to solve this problem.
> Thanks
|||Hi Linchi,
Yes, i mean the cluster administrator. I have two clustergroups named "SQL
cluster group" running on Server1 and the "cluster group" running on
Server2. When i start the cluster administrator i can manualy move the
cluster group to server1 without problems. Failback is also working fine. But
when i try to move the SQL cluster group to Server2 the cluster administrator
hangs and the only way to get the SQL cluster group running on server2 is
taking server1 offline. the same problem occurs when i try to failback to
server 1.
The SQL cluster group contains the folowing resources:
-Disk R
-SQL IP address
-MSMQ
-SQL network name
-SQL server
-SQL Server agent
-SQL Server Fulltext
Also i did the following test:
When i take the SQL server resource offline i can move the SQL cluster group
between the 2 servers. and when i take the SQL server resource online again a
try the same the cluster administrator hangs.
Note: Server2 acts as 2003 DC and DNS server
Regards,
"Linchi Shea" wrote:
> From the context, by "cluster manager" and "sql manager", I take that you
> meant "Cluster Administrator", and Cluster Administrator still reports the
> state of the cluster properly, right? (e.g. you can view whether a group is
> online and on which node the group is running, etc) In addition, the SQL
> instance itself works fine, right?
> I'd try to establish whether this is a Cluster Administrator tool problem or
> the cluster/sql problem. Try tto move the SQL group using Cluster
> Administrator on one of the nodes itself. Failing that, check to see whether
> the cluster service works properly w.r.t. the SQL group. For instance, you
> can deny the cluster service account access to the SQL instance, and this
> will force the cluster service to bounce the SQL group between the nodes
> (because its IsAlive check would fail) and eventually give up. If the cluster
> does behave this way, I'd then focus on troubleshooting the Cluster
> Adminitrator itself.
> Linchi
Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts
Sunday, March 25, 2012
cluster manager and sql authentication
I am a newbie to clustering so I hope this makes sense. Does the Cluster
Manager have to be in the sysadmin role? If not, what are the roles that it
does require?
Thanks for any guidance.
Neil
The Cluster Service must be a local admin on each server. The Cluster
Manager application is an MMC snap-in and can run wherever. Specific
cluster functions may need specific security role membership. I generally
give the person who administers a Cluster local administrator rights on each
node.
Geoff N. Hiten
Microsoft SQL Server MVP
"Neil W." <neilw@.netlib.com> wrote in message
news:%23VNuQeCeFHA.2604@.TK2MSFTNGP15.phx.gbl...
>I am a newbie to clustering so I hope this makes sense. Does the Cluster
> Manager have to be in the sysadmin role? If not, what are the roles that
> it
> does require?
> Thanks for any guidance.
> Neil
>
>
|||Thanks for the reply. The cluster manager appears to login with Windows
login: domain\Cluster. However, I cannot locate a domain user or a local
user named "Cluster". Am I missing something?
______________________
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:usU0lhCeFHA.1136@.TK2MSFTNGP12.phx.gbl...
The Cluster Service must be a local admin on each server. The Cluster
Manager application is an MMC snap-in and can run wherever. Specific
cluster functions may need specific security role membership. I generally
give the person who administers a Cluster local administrator rights on each
node.
Geoff N. Hiten
Microsoft SQL Server MVP
"Neil W." <neilw@.netlib.com> wrote in message
news:%23VNuQeCeFHA.2604@.TK2MSFTNGP15.phx.gbl...
>I am a newbie to clustering so I hope this makes sense. Does the Cluster
> Manager have to be in the sysadmin role? If not, what are the roles that
> it
> does require?
> Thanks for any guidance.
> Neil
>
>
|||Are you sure? The cluster service account should be a domain-level account
with local admin rights on each node. There should be a domain account that
matches the service account.
Geoff N. Hiten
Microsoft SQL Server MVP
"Neil W." <neilw@.REMOVEnetlib.com> wrote in message
news:eK6Ut7CeFHA.1448@.TK2MSFTNGP14.phx.gbl...
> Thanks for the reply. The cluster manager appears to login with Windows
> login: domain\Cluster. However, I cannot locate a domain user or a local
> user named "Cluster". Am I missing something?
> ______________________
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:usU0lhCeFHA.1136@.TK2MSFTNGP12.phx.gbl...
> The Cluster Service must be a local admin on each server. The Cluster
> Manager application is an MMC snap-in and can run wherever. Specific
> cluster functions may need specific security role membership. I generally
> give the person who administers a Cluster local administrator rights on
> each
> node.
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
> "Neil W." <neilw@.netlib.com> wrote in message
> news:%23VNuQeCeFHA.2604@.TK2MSFTNGP15.phx.gbl...
>
>
Manager have to be in the sysadmin role? If not, what are the roles that it
does require?
Thanks for any guidance.
Neil
The Cluster Service must be a local admin on each server. The Cluster
Manager application is an MMC snap-in and can run wherever. Specific
cluster functions may need specific security role membership. I generally
give the person who administers a Cluster local administrator rights on each
node.
Geoff N. Hiten
Microsoft SQL Server MVP
"Neil W." <neilw@.netlib.com> wrote in message
news:%23VNuQeCeFHA.2604@.TK2MSFTNGP15.phx.gbl...
>I am a newbie to clustering so I hope this makes sense. Does the Cluster
> Manager have to be in the sysadmin role? If not, what are the roles that
> it
> does require?
> Thanks for any guidance.
> Neil
>
>
|||Thanks for the reply. The cluster manager appears to login with Windows
login: domain\Cluster. However, I cannot locate a domain user or a local
user named "Cluster". Am I missing something?
______________________
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:usU0lhCeFHA.1136@.TK2MSFTNGP12.phx.gbl...
The Cluster Service must be a local admin on each server. The Cluster
Manager application is an MMC snap-in and can run wherever. Specific
cluster functions may need specific security role membership. I generally
give the person who administers a Cluster local administrator rights on each
node.
Geoff N. Hiten
Microsoft SQL Server MVP
"Neil W." <neilw@.netlib.com> wrote in message
news:%23VNuQeCeFHA.2604@.TK2MSFTNGP15.phx.gbl...
>I am a newbie to clustering so I hope this makes sense. Does the Cluster
> Manager have to be in the sysadmin role? If not, what are the roles that
> it
> does require?
> Thanks for any guidance.
> Neil
>
>
|||Are you sure? The cluster service account should be a domain-level account
with local admin rights on each node. There should be a domain account that
matches the service account.
Geoff N. Hiten
Microsoft SQL Server MVP
"Neil W." <neilw@.REMOVEnetlib.com> wrote in message
news:eK6Ut7CeFHA.1448@.TK2MSFTNGP14.phx.gbl...
> Thanks for the reply. The cluster manager appears to login with Windows
> login: domain\Cluster. However, I cannot locate a domain user or a local
> user named "Cluster". Am I missing something?
> ______________________
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:usU0lhCeFHA.1136@.TK2MSFTNGP12.phx.gbl...
> The Cluster Service must be a local admin on each server. The Cluster
> Manager application is an MMC snap-in and can run wherever. Specific
> cluster functions may need specific security role membership. I generally
> give the person who administers a Cluster local administrator rights on
> each
> node.
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
> "Neil W." <neilw@.netlib.com> wrote in message
> news:%23VNuQeCeFHA.2604@.TK2MSFTNGP15.phx.gbl...
>
>
Saturday, February 25, 2012
Cllient Unable to establish connection
Hi Am using a SQL 2k server and have been regularly logging into other SQL 2K servers in the network using the SQL Query Analyser/Enterprise Manager. After suffering a BSD yesterday, unable to log in to any server from my Query Analyser/Enterprise Manager - get this error: "Client Unable to Establish Connection".
Others are also not able establish connection - they get a General Network error when trying to connecting to my server.
Think the Blue screen death corrupted some SQL driver in the process. Now am apprehensive about uninstalling and re-installing the SQL server since am unable to backup the databases.
Can anybody help please?SQL 2k?
I find it very unlikely...did you bounce the box?
Did and admin revoke your rights?
Blue screen of death? Haven;'t seen that in a loong while.
What o/s and what patches?|||SQL 2K with SP 3. Running on Win 2k (SP4) Server. There has been no change in the admin rights. it just stopped working after the crash.
that's why its confusing.. not much help from Miscrosoft either.
Originally posted by Brett Kaiser
SQL 2k?
I find it very unlikely...did you bounce the box?
Did and admin revoke your rights?
Blue screen of death? Haven;'t seen that in a loong while.
What o/s and what patches?|||Check your Client Config utility ? Try creating an alias using TCP/IP ..
What SQl Client you are using from where you accessing SQL Server ..?|||Tried the Client Network Utility - the TCP/IP option is not enabled when i try to add an alias. Only the Multiple Protocol, Apple Talk, VIA and "Other" options are enabled.
The server is installed in my laptop and am accessing from the same machine using the SQL Query Analyser. The laptop is a Win2k Server (SP4).
Originally posted by aashu
Check your Client Config utility ? Try creating an alias using TCP/IP ..
What SQl Client you are using from where you accessing SQL Server ..?
Others are also not able establish connection - they get a General Network error when trying to connecting to my server.
Think the Blue screen death corrupted some SQL driver in the process. Now am apprehensive about uninstalling and re-installing the SQL server since am unable to backup the databases.
Can anybody help please?SQL 2k?
I find it very unlikely...did you bounce the box?
Did and admin revoke your rights?
Blue screen of death? Haven;'t seen that in a loong while.
What o/s and what patches?|||SQL 2K with SP 3. Running on Win 2k (SP4) Server. There has been no change in the admin rights. it just stopped working after the crash.
that's why its confusing.. not much help from Miscrosoft either.
Originally posted by Brett Kaiser
SQL 2k?
I find it very unlikely...did you bounce the box?
Did and admin revoke your rights?
Blue screen of death? Haven;'t seen that in a loong while.
What o/s and what patches?|||Check your Client Config utility ? Try creating an alias using TCP/IP ..
What SQl Client you are using from where you accessing SQL Server ..?|||Tried the Client Network Utility - the TCP/IP option is not enabled when i try to add an alias. Only the Multiple Protocol, Apple Talk, VIA and "Other" options are enabled.
The server is installed in my laptop and am accessing from the same machine using the SQL Query Analyser. The laptop is a Win2k Server (SP4).
Originally posted by aashu
Check your Client Config utility ? Try creating an alias using TCP/IP ..
What SQl Client you are using from where you accessing SQL Server ..?
Friday, February 24, 2012
Clients not installing
Getting this error...
SMS Client Configuration Manager cannot connect to the machine
"ComputerName". The operating system reported error 1314: A required
privilege is not held by the client.
Possible cause: The client is not accessible.
Solution: Verify that the client is connected to the network and that the
SMS Service account or (if specified) the SMS Client Remote Installation
account have the required privileges, as specified in the SMS documentation.
Does the account I specified in Connection Accounts need to have local admin
perms? How can I double check?
Jason
Crap wrong group...sorry.
"JasonMeyer" <jason.meyer@.nospam.isd623.org> wrote in message
news:euwoiFFPFHA.3072@.TK2MSFTNGP09.phx.gbl...
> Getting this error...
> SMS Client Configuration Manager cannot connect to the machine
> "ComputerName". The operating system reported error 1314: A required
> privilege is not held by the client.
> Possible cause: The client is not accessible.
> Solution: Verify that the client is connected to the network and that the
> SMS Service account or (if specified) the SMS Client Remote Installation
> account have the required privileges, as specified in the SMS
> documentation.
> Does the account I specified in Connection Accounts need to have local
> admin perms? How can I double check?
> Jason
>
SMS Client Configuration Manager cannot connect to the machine
"ComputerName". The operating system reported error 1314: A required
privilege is not held by the client.
Possible cause: The client is not accessible.
Solution: Verify that the client is connected to the network and that the
SMS Service account or (if specified) the SMS Client Remote Installation
account have the required privileges, as specified in the SMS documentation.
Does the account I specified in Connection Accounts need to have local admin
perms? How can I double check?
Jason
Crap wrong group...sorry.
"JasonMeyer" <jason.meyer@.nospam.isd623.org> wrote in message
news:euwoiFFPFHA.3072@.TK2MSFTNGP09.phx.gbl...
> Getting this error...
> SMS Client Configuration Manager cannot connect to the machine
> "ComputerName". The operating system reported error 1314: A required
> privilege is not held by the client.
> Possible cause: The client is not accessible.
> Solution: Verify that the client is connected to the network and that the
> SMS Service account or (if specified) the SMS Client Remote Installation
> account have the required privileges, as specified in the SMS
> documentation.
> Does the account I specified in Connection Accounts need to have local
> admin perms? How can I double check?
> Jason
>
Client utilities for MSDE
Hi,
I heard from a guy that the client utilities (Enterprice Manager and Query Analyser) that are on the Sql Server 2000 CD can be fetched separatly from Microsoft and that they can be deployed with MSDE to a potential customer.
Is that correct?
And if it is, where can I obtain those client apps?
TIA
OhlywohlyNope. You can't get the client utilities for free (legally), and deploy it to a customer.
http://msdn.microsoft.com/sql/downloads/tools/default.aspx
That's what you're limited to.|||You absolutely cannot deploy the Client Tools with MSDE to a customer! The whole point of MSDE is that it's an engine and your application should supply the means necessary to manage it.
If the client already owns a version of SQL Server then they may legally use the Client Tools to manage MSDE.
Unfortunately the Client Tools are not available for purchase separately. You might consider a set of 3rd party tools.
Terri
Disclaimer: I am not a lawyer nor a licensing expert
Sunday, February 19, 2012
Client side SQL manager tool?
I host my website with a 3rd party and need something to manage my SQL
database. Can someone please recommend a good client side tool for XP?
Thanks.MS has a free web-based SQL admin tool you might take a look at...
Duh! Now that I think about it, you can still use SQL Enterprise Manager ,
just register and connect to the IP and port number...
Also ask your hosting company, many provide tools for you.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob Smith" <noemail@.please.com> wrote in message
news:lDHjd.39122$Om6.2911@.bignews5.bellsouth.net...
> I host my website with a 3rd party and need something to manage my SQL
> database. Can someone please recommend a good client side tool for XP?
> Thanks.
>|||Hi Bob,
Thanks MVP Wayne for his perfect suggestions and here is some links for
your reference
Download: SQL Server Web Data Administrator
http://www.microsoft.com/downloads/...A798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file
system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Bob,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
database. Can someone please recommend a good client side tool for XP?
Thanks.MS has a free web-based SQL admin tool you might take a look at...
Duh! Now that I think about it, you can still use SQL Enterprise Manager ,
just register and connect to the IP and port number...
Also ask your hosting company, many provide tools for you.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob Smith" <noemail@.please.com> wrote in message
news:lDHjd.39122$Om6.2911@.bignews5.bellsouth.net...
> I host my website with a 3rd party and need something to manage my SQL
> database. Can someone please recommend a good client side tool for XP?
> Thanks.
>|||Hi Bob,
Thanks MVP Wayne for his perfect suggestions and here is some links for
your reference
Download: SQL Server Web Data Administrator
http://www.microsoft.com/downloads/...A798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file
system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Bob,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Client side SQL manager tool?
I host my website with a 3rd party and need something to manage my SQL
database. Can someone please recommend a good client side tool for XP?
Thanks.
MS has a free web-based SQL admin tool you might take a look at...
Duh! Now that I think about it, you can still use SQL Enterprise Manager ,
just register and connect to the IP and port number...
Also ask your hosting company, many provide tools for you.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob Smith" <noemail@.please.com> wrote in message
news:lDHjd.39122$Om6.2911@.bignews5.bellsouth.net.. .
> I host my website with a 3rd party and need something to manage my SQL
> database. Can someone please recommend a good client side tool for XP?
> Thanks.
>
|||Hi Bob,
Thanks MVP Wayne for his perfect suggestions and here is some links for
your reference
Download: SQL Server Web Data Administrator
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file
system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Bob,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
database. Can someone please recommend a good client side tool for XP?
Thanks.
MS has a free web-based SQL admin tool you might take a look at...
Duh! Now that I think about it, you can still use SQL Enterprise Manager ,
just register and connect to the IP and port number...
Also ask your hosting company, many provide tools for you.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob Smith" <noemail@.please.com> wrote in message
news:lDHjd.39122$Om6.2911@.bignews5.bellsouth.net.. .
> I host my website with a 3rd party and need something to manage my SQL
> database. Can someone please recommend a good client side tool for XP?
> Thanks.
>
|||Hi Bob,
Thanks MVP Wayne for his perfect suggestions and here is some links for
your reference
Download: SQL Server Web Data Administrator
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file
system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Bob,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Client side SQL manager tool?
I host my website with a 3rd party and need something to manage my SQL
database. Can someone please recommend a good client side tool for XP?
Thanks.MS has a free web-based SQL admin tool you might take a look at...
Duh! Now that I think about it, you can still use SQL Enterprise Manager ,
just register and connect to the IP and port number...
Also ask your hosting company, many provide tools for you.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob Smith" <noemail@.please.com> wrote in message
news:lDHjd.39122$Om6.2911@.bignews5.bellsouth.net...
> I host my website with a 3rd party and need something to manage my SQL
> database. Can someone please recommend a good client side tool for XP?
> Thanks.
>|||Hi Bob,
Thanks MVP Wayne for his perfect suggestions and here is some links for
your reference:)
Download: SQL Server Web Data Administrator
http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file
system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Bob,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
database. Can someone please recommend a good client side tool for XP?
Thanks.MS has a free web-based SQL admin tool you might take a look at...
Duh! Now that I think about it, you can still use SQL Enterprise Manager ,
just register and connect to the IP and port number...
Also ask your hosting company, many provide tools for you.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob Smith" <noemail@.please.com> wrote in message
news:lDHjd.39122$Om6.2911@.bignews5.bellsouth.net...
> I host my website with a 3rd party and need something to manage my SQL
> database. Can someone please recommend a good client side tool for XP?
> Thanks.
>|||Hi Bob,
Thanks MVP Wayne for his perfect suggestions and here is some links for
your reference:)
Download: SQL Server Web Data Administrator
http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file
system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Bob,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Thursday, February 16, 2012
Client Network Utility
I have created a SQL2000 database on our server. I am trying to run the serv
ice using the Service Manager.
I have already created an alias using Client Network Utility - TCPIP.
But every time i select the service i get The network path is not found.
ANy ideas ?You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?|||The service is running on my server, and i have tried pinging the server fro
m my laptop, but still no luck !|||I received a reply from my server when i pinged it.
ice using the Service Manager.
I have already created an alias using Client Network Utility - TCPIP.
But every time i select the service i get The network path is not found.
ANy ideas ?You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?|||The service is running on my server, and i have tried pinging the server fro
m my laptop, but still no luck !|||I received a reply from my server when i pinged it.
Client Network Utility
I have created a SQL2000 database on our server. I am trying to run the service using the Service Manager.
I have already created an alias using Client Network Utility - TCPIP.
But every time i select the service i get The network path is not found.
ANy ideas ?
You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?
|||The service is running on my server, and i have tried pinging the server from my laptop, but still no luck !
|||I received a reply from my server when i pinged it.
I have already created an alias using Client Network Utility - TCPIP.
But every time i select the service i get The network path is not found.
ANy ideas ?
You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?
|||The service is running on my server, and i have tried pinging the server from my laptop, but still no luck !
|||I received a reply from my server when i pinged it.
Client Network Utility
I have created a SQL2000 database on our server. I am trying to run the service using the Service Manager
I have already created an alias using Client Network Utility - TCPIP
But every time i select the service i get The network path is not found
ANy ideas ?You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?|||The service is running on my server, and i have tried pinging the server from my laptop, but still no luck|||I received a reply from my server when i pinged it
I have already created an alias using Client Network Utility - TCPIP
But every time i select the service i get The network path is not found
ANy ideas ?You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?|||The service is running on my server, and i have tried pinging the server from my laptop, but still no luck|||I received a reply from my server when i pinged it
Tuesday, February 14, 2012
Client found response content type of ''text/html; charset=utf-8'', but expected ''text/xm
Hi,
I am getting these errors from Report Manager. It seems that every time after the server has been idling for about 15 minutes, I would get this error message. I can click on other links and I am able to continue to use Report Manager.
Is there a timeout setting to help me resolve this or is this a bug with Report Manager? I just insitalled SP2 on the SQL Server and the Reporting Service.
Error message on browser:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.3042.00" /> <meta name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9" /> <meta name="CountryLocaleID" content="1033" /> <style> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR![[:#]](http://pics.10026.com/?src=http://forums.microsoft.com/MSDN/emoticons/emotion-16.gif)
3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300; TEXT-DECORATION:underline} A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300; TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul> <li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3042.00" target="_blank">Get Online Help</a></li><ul> <li>For more information about this error navigate to the report server on the local server machine, or enable remote errors</li> </ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span> </ul> </body> --.
Any ideas?
Thanks,
-waslam
Maybe this will help you:
http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx
Client found response content type of ''text/html; charset=utf-8'', but expected ''text/xm
Hi,
I am getting these errors from Report Manager. It seems that every time after the server has been idling for about 15 minutes, I would get this error message. I can click on other links and I am able to continue to use Report Manager.
Is there a timeout setting to help me resolve this or is this a bug with Report Manager? I just insitalled SP2 on the SQL Server and the Reporting Service.
Error message on browser:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.3042.00" /> <meta name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9" /> <meta name="CountryLocaleID" content="1033" /> <style> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300; TEXT-DECORATION:underline} A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300; TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul> <li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3042.00" target="_blank">Get Online Help</a></li><ul> <li>For more information about this error navigate to the report server on the local server machine, or enable remote errors</li> </ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span> </ul> </body> --.
Any ideas?
Thanks,
-waslam
Maybe this will help you:
http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx
Subscribe to:
Posts (Atom)