Hi
We recently had a SQL Server 2K, Win2K box crash on us, and we had to
reinstall Windows.
Sql Server was also damaged (I think the registry got corrupted), and
so I reinstalled that too (couldnt start the Services). The server is
now up and running, but from any other computers (such as my desktop)
I can't connect to the server. If I open QA, for example, I can locate
the server name using the ... button (so it's there), but when I put
in a UID & PWD I get the "SQL Server does not exist or access denied"
error.
If I start QA on the server itself, though, and connect using the same
UID & PWD, there's no problem.
any ideas?
Thanks
SeanEnsure that both the server and client share a network protocol in common.
Try to ping the server name and IP from the client to ensure connectivity.
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
"Sean" <plugwalsh@.yahoo.com> wrote in message
news:3698af3c.0408100316.2596d560@.posting.google.com...
> Hi
> We recently had a SQL Server 2K, Win2K box crash on us, and we had to
> reinstall Windows.
> Sql Server was also damaged (I think the registry got corrupted), and
> so I reinstalled that too (couldnt start the Services). The server is
> now up and running, but from any other computers (such as my desktop)
> I can't connect to the server. If I open QA, for example, I can locate
> the server name using the ... button (so it's there), but when I put
> in a UID & PWD I get the "SQL Server does not exist or access denied"
> error.
> If I start QA on the server itself, though, and connect using the same
> UID & PWD, there's no problem.
> any ideas?
> Thanks
> Sean|||Sorry - had the wrong IP in the hosts file... doh!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message news:<uIsqD7sfEHA.396@.
TK2MSFTNGP12.phx.gbl>...[vbcol=seagreen]
> Ensure that both the server and client share a network protocol in common.
> Try to ping the server name and IP from the client to ensure connectivity.
> --
> 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
> "Sean" <plugwalsh@.yahoo.com> wrote in message
> news:3698af3c.0408100316.2596d560@.posting.google.com...
Showing posts with label hiwe. Show all posts
Showing posts with label hiwe. Show all posts
Thursday, March 29, 2012
Cant Connect - SQL Server does not exist
Hi
We recently had a SQL Server 2K, Win2K box crash on us, and we had to
reinstall Windows.
Sql Server was also damaged (I think the registry got corrupted), and
so I reinstalled that too (couldnt start the Services). The server is
now up and running, but from any other computers (such as my desktop)
I can't connect to the server. If I open QA, for example, I can locate
the server name using the ... button (so it's there), but when I put
in a UID & PWD I get the "SQL Server does not exist or access denied"
error.
If I start QA on the server itself, though, and connect using the same
UID & PWD, there's no problem.
any ideas?
Thanks
Sean
Ensure that both the server and client share a network protocol in common.
Try to ping the server name and IP from the client to ensure connectivity.
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
"Sean" <plugwalsh@.yahoo.com> wrote in message
news:3698af3c.0408100316.2596d560@.posting.google.c om...
> Hi
> We recently had a SQL Server 2K, Win2K box crash on us, and we had to
> reinstall Windows.
> Sql Server was also damaged (I think the registry got corrupted), and
> so I reinstalled that too (couldnt start the Services). The server is
> now up and running, but from any other computers (such as my desktop)
> I can't connect to the server. If I open QA, for example, I can locate
> the server name using the ... button (so it's there), but when I put
> in a UID & PWD I get the "SQL Server does not exist or access denied"
> error.
> If I start QA on the server itself, though, and connect using the same
> UID & PWD, there's no problem.
> any ideas?
> Thanks
> Sean
|||Sorry - had the wrong IP in the hosts file... doh!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message news:<uIsqD7sfEHA.396@.TK2MSFTNGP12.phx.gbl>...[vbcol=seagreen]
> Ensure that both the server and client share a network protocol in common.
> Try to ping the server name and IP from the client to ensure connectivity.
> --
> 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
> "Sean" <plugwalsh@.yahoo.com> wrote in message
> news:3698af3c.0408100316.2596d560@.posting.google.c om...
We recently had a SQL Server 2K, Win2K box crash on us, and we had to
reinstall Windows.
Sql Server was also damaged (I think the registry got corrupted), and
so I reinstalled that too (couldnt start the Services). The server is
now up and running, but from any other computers (such as my desktop)
I can't connect to the server. If I open QA, for example, I can locate
the server name using the ... button (so it's there), but when I put
in a UID & PWD I get the "SQL Server does not exist or access denied"
error.
If I start QA on the server itself, though, and connect using the same
UID & PWD, there's no problem.
any ideas?
Thanks
Sean
Ensure that both the server and client share a network protocol in common.
Try to ping the server name and IP from the client to ensure connectivity.
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
"Sean" <plugwalsh@.yahoo.com> wrote in message
news:3698af3c.0408100316.2596d560@.posting.google.c om...
> Hi
> We recently had a SQL Server 2K, Win2K box crash on us, and we had to
> reinstall Windows.
> Sql Server was also damaged (I think the registry got corrupted), and
> so I reinstalled that too (couldnt start the Services). The server is
> now up and running, but from any other computers (such as my desktop)
> I can't connect to the server. If I open QA, for example, I can locate
> the server name using the ... button (so it's there), but when I put
> in a UID & PWD I get the "SQL Server does not exist or access denied"
> error.
> If I start QA on the server itself, though, and connect using the same
> UID & PWD, there's no problem.
> any ideas?
> Thanks
> Sean
|||Sorry - had the wrong IP in the hosts file... doh!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message news:<uIsqD7sfEHA.396@.TK2MSFTNGP12.phx.gbl>...[vbcol=seagreen]
> Ensure that both the server and client share a network protocol in common.
> Try to ping the server name and IP from the client to ensure connectivity.
> --
> 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
> "Sean" <plugwalsh@.yahoo.com> wrote in message
> news:3698af3c.0408100316.2596d560@.posting.google.c om...
Thursday, March 8, 2012
cannot update
Hi
we moved from 2000 to 2003 (version 9)
I do Open Table to see all rows
when I try to change a value say 2 to 3 in int field it pops up dialog and
say
like driver error string or binary data will be truncated
but it is an integer field and the values are like 2 and 3!
is it isolation level related perhaps
what setting is it
we just installed it so it must be default
Sincerely
GSL
Hi
"info@.sites4agents.com" wrote:
> Hi
> we moved from 2000 to 2003 (version 9)
> I do Open Table to see all rows
> when I try to change a value say 2 to 3 in int field it pops up dialog and
> say
> like driver error string or binary data will be truncated
> but it is an integer field and the values are like 2 and 3!
> is it isolation level related perhaps
> what setting is it
> we just installed it so it must be default
> Sincerely
> GSL
This should not be an issue under normal circumstances. Have you service
packed your version of SQL 2005? Are you trying this on a client or the
server itself?
Are there any triggers on the table?
John
|||John
Thanks
No SPs as far as I know (how will I know?)
the table does have text column but then in sql2000 it was updatable
manually
No triggers
I do it on the server
also! when I do it in Query like regular update statement it works!
(so maybe it forces good habits nevertheless I am curious why it happens)
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:25EACFD4-9897-4D6E-AEA6-E7936186542A@.microsoft.com...
> Hi
> "info@.sites4agents.com" wrote:
>
> This should not be an issue under normal circumstances. Have you service
> packed your version of SQL 2005? Are you trying this on a client or the
> server itself?
> Are there any triggers on the table?
> John
>
|||Hi
"info@.sites4agents.com" wrote:
> John
> Thanks
> No SPs as far as I know (how will I know?)
Select @.@.VERSION will give you the version number also SELECT
SERVERPROPTERY('ProductLevel ') will tell if a service pack has been applied
or is still at the original release (RTM). See
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html for more.
> the table does have text column but then in sql2000 it was updatable
> manually
> No triggers
> I do it on the server
> also! when I do it in Query like regular update statement it works!
> (so maybe it forces good habits nevertheless I am curious why it happens)
The error message you have seems to be a SQL Server error message, if you
have the error number it would be useful. You could post DDL and example data
http://www.aspfaq.com/etiquette.asp?id=5006 to help others re-create this.
Open table in Enterprise Manager was always quirky therefore it is not
something a lot of people will use in SQL 2005 because of that.
John
we moved from 2000 to 2003 (version 9)
I do Open Table to see all rows
when I try to change a value say 2 to 3 in int field it pops up dialog and
say
like driver error string or binary data will be truncated
but it is an integer field and the values are like 2 and 3!
is it isolation level related perhaps
what setting is it
we just installed it so it must be default
Sincerely
GSL
Hi
"info@.sites4agents.com" wrote:
> Hi
> we moved from 2000 to 2003 (version 9)
> I do Open Table to see all rows
> when I try to change a value say 2 to 3 in int field it pops up dialog and
> say
> like driver error string or binary data will be truncated
> but it is an integer field and the values are like 2 and 3!
> is it isolation level related perhaps
> what setting is it
> we just installed it so it must be default
> Sincerely
> GSL
This should not be an issue under normal circumstances. Have you service
packed your version of SQL 2005? Are you trying this on a client or the
server itself?
Are there any triggers on the table?
John
|||John
Thanks
No SPs as far as I know (how will I know?)
the table does have text column but then in sql2000 it was updatable
manually
No triggers
I do it on the server
also! when I do it in Query like regular update statement it works!
(so maybe it forces good habits nevertheless I am curious why it happens)
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:25EACFD4-9897-4D6E-AEA6-E7936186542A@.microsoft.com...
> Hi
> "info@.sites4agents.com" wrote:
>
> This should not be an issue under normal circumstances. Have you service
> packed your version of SQL 2005? Are you trying this on a client or the
> server itself?
> Are there any triggers on the table?
> John
>
|||Hi
"info@.sites4agents.com" wrote:
> John
> Thanks
> No SPs as far as I know (how will I know?)
Select @.@.VERSION will give you the version number also SELECT
SERVERPROPTERY('ProductLevel ') will tell if a service pack has been applied
or is still at the original release (RTM). See
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html for more.
> the table does have text column but then in sql2000 it was updatable
> manually
> No triggers
> I do it on the server
> also! when I do it in Query like regular update statement it works!
> (so maybe it forces good habits nevertheless I am curious why it happens)
The error message you have seems to be a SQL Server error message, if you
have the error number it would be useful. You could post DDL and example data
http://www.aspfaq.com/etiquette.asp?id=5006 to help others re-create this.
Open table in Enterprise Manager was always quirky therefore it is not
something a lot of people will use in SQL 2005 because of that.
John
cannot update
Hi
we moved from 2000 to 2003 (version 9)
I do Open Table to see all rows
when I try to change a value say 2 to 3 in int field it pops up dialog and
say
like driver error string or binary data will be truncated
but it is an integer field and the values are like 2 and 3!
is it isolation level related perhaps
what setting is it
we just installed it so it must be default
Sincerely
GSLHi
"info@.sites4agents.com" wrote:
> Hi
> we moved from 2000 to 2003 (version 9)
> I do Open Table to see all rows
> when I try to change a value say 2 to 3 in int field it pops up dialog and
> say
> like driver error string or binary data will be truncated
> but it is an integer field and the values are like 2 and 3!
> is it isolation level related perhaps
> what setting is it
> we just installed it so it must be default
> Sincerely
> GSL
This should not be an issue under normal circumstances. Have you service
packed your version of SQL 2005? Are you trying this on a client or the
server itself?
Are there any triggers on the table?
John|||John
Thanks
No SPs as far as I know (how will I know?)
the table does have text column but then in sql2000 it was updatable
manually
No triggers
I do it on the server
also! when I do it in Query like regular update statement it works!
(so maybe it forces good habits nevertheless I am curious why it happens)
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:25EACFD4-9897-4D6E-AEA6-E7936186542A@.microsoft.com...
> Hi
> "info@.sites4agents.com" wrote:
>
> This should not be an issue under normal circumstances. Have you service
> packed your version of SQL 2005? Are you trying this on a client or the
> server itself?
> Are there any triggers on the table?
> John
>|||Hi
"info@.sites4agents.com" wrote:
> John
> Thanks
> No SPs as far as I know (how will I know?)
Select @.@.VERSION will give you the version number also SELECT
SERVERPROPTERY('ProductLevel ') will tell if a service pack has been applied
or is still at the original release (RTM). See
http://sqlserver2000.databases.aspf...-m-running.html for more.
> the table does have text column but then in sql2000 it was updatable
> manually
> No triggers
> I do it on the server
> also! when I do it in Query like regular update statement it works!
> (so maybe it forces good habits nevertheless I am curious why it happens)
The error message you have seems to be a SQL Server error message, if you
have the error number it would be useful. You could post DDL and example dat
a
http://www.aspfaq.com/etiquette.asp?id=5006 to help others re-create this.
Open table in Enterprise Manager was always quirky therefore it is not
something a lot of people will use in SQL 2005 because of that.
John
we moved from 2000 to 2003 (version 9)
I do Open Table to see all rows
when I try to change a value say 2 to 3 in int field it pops up dialog and
say
like driver error string or binary data will be truncated
but it is an integer field and the values are like 2 and 3!
is it isolation level related perhaps
what setting is it
we just installed it so it must be default
Sincerely
GSLHi
"info@.sites4agents.com" wrote:
> Hi
> we moved from 2000 to 2003 (version 9)
> I do Open Table to see all rows
> when I try to change a value say 2 to 3 in int field it pops up dialog and
> say
> like driver error string or binary data will be truncated
> but it is an integer field and the values are like 2 and 3!
> is it isolation level related perhaps
> what setting is it
> we just installed it so it must be default
> Sincerely
> GSL
This should not be an issue under normal circumstances. Have you service
packed your version of SQL 2005? Are you trying this on a client or the
server itself?
Are there any triggers on the table?
John|||John
Thanks
No SPs as far as I know (how will I know?)
the table does have text column but then in sql2000 it was updatable
manually
No triggers
I do it on the server
also! when I do it in Query like regular update statement it works!
(so maybe it forces good habits nevertheless I am curious why it happens)
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:25EACFD4-9897-4D6E-AEA6-E7936186542A@.microsoft.com...
> Hi
> "info@.sites4agents.com" wrote:
>
> This should not be an issue under normal circumstances. Have you service
> packed your version of SQL 2005? Are you trying this on a client or the
> server itself?
> Are there any triggers on the table?
> John
>|||Hi
"info@.sites4agents.com" wrote:
> John
> Thanks
> No SPs as far as I know (how will I know?)
Select @.@.VERSION will give you the version number also SELECT
SERVERPROPTERY('ProductLevel ') will tell if a service pack has been applied
or is still at the original release (RTM). See
http://sqlserver2000.databases.aspf...-m-running.html for more.
> the table does have text column but then in sql2000 it was updatable
> manually
> No triggers
> I do it on the server
> also! when I do it in Query like regular update statement it works!
> (so maybe it forces good habits nevertheless I am curious why it happens)
The error message you have seems to be a SQL Server error message, if you
have the error number it would be useful. You could post DDL and example dat
a
http://www.aspfaq.com/etiquette.asp?id=5006 to help others re-create this.
Open table in Enterprise Manager was always quirky therefore it is not
something a lot of people will use in SQL 2005 because of that.
John
Subscribe to:
Posts (Atom)