can't access server from another PC

I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
that I have been unable to access the SQL Server on my laptop from another
PC. When I go to register it from another PC I get:
"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
Reason: SQL Server does not exist or access denied.
ConnectionOpen(Connect())"
The database is indeed running so I assume it must be some type of
permission problem. Both PCs are in the same domain. I have tried to connect
using Windows account information and SQL Server login information - both
get the same error. I also tried to connect from another PC to the laptop
with the same error. The laptop can see and access databases on each of
these other PC's so it is just reading from the laptop that is not possible.
I did disable my Norton Internet Security to make sure that the firewall
wasn't interferring but still get the same error.
I'm pulling my hair out and could really use your help. Thanks for taking
the time to read this.
InNeedOfAssistance wrote:
>I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
>that I have been unable to access the SQL Server on my laptop from another
>PC. When I go to register it from another PC I get:
>"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect())"
>The database is indeed running so I assume it must be some type of
>permission problem. Both PCs are in the same domain. I have tried to connect
>using Windows account information and SQL Server login information - both
>get the same error. I also tried to connect from another PC to the laptop
>with the same error. The laptop can see and access databases on each of
>these other PC's so it is just reading from the laptop that is not possible.
>I did disable my Norton Internet Security to make sure that the firewall
>wasn't interferring but still get the same error.
>I'm pulling my hair out and could really use your help. Thanks for taking
>the time to read this.
Are you trying to login via Windows Authentication ? as the error message
seems that this login does not exist in the Security Logins. Do you have an
SQL Server ID you can just prove its Windows Auth with by logging in via that?
Alternatively I have had the problem with OS's where it uses Netpipes by
default which are blocked by the network, to prove this create an ODBC with
IP /Port to the SQL Server and prove this works.
Message posted via http://www.droptable.com
|||InNeedOfAssistance wrote:
>I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
>that I have been unable to access the SQL Server on my laptop from another
>PC. When I go to register it from another PC I get:
>"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect())"
>The database is indeed running so I assume it must be some type of
>permission problem. Both PCs are in the same domain. I have tried to connect
>using Windows account information and SQL Server login information - both
>get the same error. I also tried to connect from another PC to the laptop
>with the same error. The laptop can see and access databases on each of
>these other PC's so it is just reading from the laptop that is not possible.
>I did disable my Norton Internet Security to make sure that the firewall
>wasn't interferring but still get the same error.
>I'm pulling my hair out and could really use your help. Thanks for taking
>the time to read this.
Are you trying to login via Windows Authentication ? as the error message
seems that this login does not exist in the Security Logins. Do you have an
SQL Server ID you can just prove its Windows Auth with by logging in via that?
Alternatively I have had the problem with OS's where it uses Netpipes by
default which are blocked by the network, to prove this create an ODBC with
IP /Port to the SQL Server and prove this works.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200704/1
|||> Are you trying to login via Windows Authentication ? as the error message
> seems that this login does not exist in the Security Logins. Do you have
> an
> SQL Server ID you can just prove its Windows Auth with by logging in via
> that?
I tried to login with the sa account when I used SQL Server login
information and a login that I know is valid on my laptop for the Windows
account information login.
Probably another important piece of information that I didn't mention is
that when trying to register this database from another PC, it never is
displayed as one of the available databases. There is a NAME-LAPTOP database
that shows as available (I assume the default from installing Visual Studio)
but no NAME-LAPTOP\NAME_LAPTOP database as this one is called. I was
wondering if it might help to uninstall and reinstall SQL Server. Do you
know if there are ever any conflict between the Visual Studio db and the
main SQL Server db depending on install order? At this point, I don't
remember which I installed first. At one point, I had installed the Visual
InterDev on the laptop by accident but deleted that and installed Visual
Studio. I don't know if that could have messed anything up or not too.
Using Visual Studio on the laptop I can connect to the
NAME-LAPTOP\NAME_LAPTOP database but if I go to another PC I can't connect
using Visual Studio.

> Alternatively I have had the problem with OS's where it uses Netpipes by
> default which are blocked by the network, to prove this create an ODBC
> with
> IP /Port to the SQL Server and prove this works.
Do you mean create a script to see if I can login that way?.

> --
> Message posted via http://www.droptable.com
>
|||Just to let you all know - the uninstall and reinstall of the database on my
laptop fixed all my problems. I'm sorry I didn't try that from the
beginning.

can't access server from another PC

I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
that I have been unable to access the SQL Server on my laptop from another
PC. When I go to register it from another PC I get:
"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
Reason: SQL Server does not exist or access denied.
ConnectionOpen(Connect())"
The database is indeed running so I assume it must be some type of
permission problem. Both PCs are in the same domain. I have tried to connect
using Windows account information and SQL Server login information - both
get the same error. I also tried to connect from another PC to the laptop
with the same error. The laptop can see and access databases on each of
these other PC's so it is just reading from the laptop that is not possible.
I did disable my Norton Internet Security to make sure that the firewall
wasn't interferring but still get the same error.
I'm pulling my hair out and could really use your help. Thanks for taking
the time to read this.InNeedOfAssistance wrote:
>I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
>that I have been unable to access the SQL Server on my laptop from another
>PC. When I go to register it from another PC I get:
>"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect())"
>The database is indeed running so I assume it must be some type of
>permission problem. Both PCs are in the same domain. I have tried to connect
>using Windows account information and SQL Server login information - both
>get the same error. I also tried to connect from another PC to the laptop
>with the same error. The laptop can see and access databases on each of
>these other PC's so it is just reading from the laptop that is not possible.
>I did disable my Norton Internet Security to make sure that the firewall
>wasn't interferring but still get the same error.
>I'm pulling my hair out and could really use your help. Thanks for taking
>the time to read this.
Are you trying to login via Windows Authentication ? as the error message
seems that this login does not exist in the Security Logins. Do you have an
SQL Server ID you can just prove its Windows Auth with by logging in via that?
Alternatively I have had the problem with OS's where it uses Netpipes by
default which are blocked by the network, to prove this create an ODBC with
IP /Port to the SQL Server and prove this works.
--
Message posted via http://www.sqlmonster.com|||InNeedOfAssistance wrote:
>I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
>that I have been unable to access the SQL Server on my laptop from another
>PC. When I go to register it from another PC I get:
>"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect())"
>The database is indeed running so I assume it must be some type of
>permission problem. Both PCs are in the same domain. I have tried to connect
>using Windows account information and SQL Server login information - both
>get the same error. I also tried to connect from another PC to the laptop
>with the same error. The laptop can see and access databases on each of
>these other PC's so it is just reading from the laptop that is not possible.
>I did disable my Norton Internet Security to make sure that the firewall
>wasn't interferring but still get the same error.
>I'm pulling my hair out and could really use your help. Thanks for taking
>the time to read this.
Are you trying to login via Windows Authentication ? as the error message
seems that this login does not exist in the Security Logins. Do you have an
SQL Server ID you can just prove its Windows Auth with by logging in via that?
Alternatively I have had the problem with OS's where it uses Netpipes by
default which are blocked by the network, to prove this create an ODBC with
IP /Port to the SQL Server and prove this works.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200704/1|||> Are you trying to login via Windows Authentication ? as the error message
> seems that this login does not exist in the Security Logins. Do you have
> an
> SQL Server ID you can just prove its Windows Auth with by logging in via
> that?
I tried to login with the sa account when I used SQL Server login
information and a login that I know is valid on my laptop for the Windows
account information login.
Probably another important piece of information that I didn't mention is
that when trying to register this database from another PC, it never is
displayed as one of the available databases. There is a NAME-LAPTOP database
that shows as available (I assume the default from installing Visual Studio)
but no NAME-LAPTOP\NAME_LAPTOP database as this one is called. I was
wondering if it might help to uninstall and reinstall SQL Server. Do you
know if there are ever any conflict between the Visual Studio db and the
main SQL Server db depending on install order? At this point, I don't
remember which I installed first. At one point, I had installed the Visual
InterDev on the laptop by accident but deleted that and installed Visual
Studio. I don't know if that could have messed anything up or not too.
Using Visual Studio on the laptop I can connect to the
NAME-LAPTOP\NAME_LAPTOP database but if I go to another PC I can't connect
using Visual Studio.
> Alternatively I have had the problem with OS's where it uses Netpipes by
> default which are blocked by the network, to prove this create an ODBC
> with
> IP /Port to the SQL Server and prove this works.
Do you mean create a script to see if I can login that way?.
> --
> Message posted via http://www.sqlmonster.com
>|||Just to let you all know - the uninstall and reinstall of the database on my
laptop fixed all my problems. I'm sorry I didn't try that from the
beginning.

can't access server from another PC

I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
that I have been unable to access the SQL Server on my laptop from another
PC. When I go to register it from another PC I get:
"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
Reason: SQL Server does not exist or access denied.
ConnectionOpen(Connect())"
The database is indeed running so I assume it must be some type of
permission problem. Both PCs are in the same domain. I have tried to connect
using Windows account information and SQL Server login information - both
get the same error. I also tried to connect from another PC to the laptop
with the same error. The laptop can see and access databases on each of
these other PC's so it is just reading from the laptop that is not possible.
I did disable my Norton Internet Security to make sure that the firewall
wasn't interferring but still get the same error.
I'm pulling my hair out and could really use your help. Thanks for taking
the time to read this.InNeedOfAssistance wrote:
>I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
>that I have been unable to access the SQL Server on my laptop from another
>PC. When I go to register it from another PC I get:
>"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect())"
>The database is indeed running so I assume it must be some type of
>permission problem. Both PCs are in the same domain. I have tried to connec
t
>using Windows account information and SQL Server login information - both
>get the same error. I also tried to connect from another PC to the laptop
>with the same error. The laptop can see and access databases on each of
>these other PC's so it is just reading from the laptop that is not possible
.
>I did disable my Norton Internet Security to make sure that the firewall
>wasn't interferring but still get the same error.
>I'm pulling my hair out and could really use your help. Thanks for taking
>the time to read this.
Are you trying to login via Windows Authentication ? as the error message
seems that this login does not exist in the Security Logins. Do you have an
SQL Server ID you can just prove its Windows Auth with by logging in via tha
t?
Alternatively I have had the problem with OS's where it uses Netpipes by
default which are blocked by the network, to prove this create an ODBC with
IP /Port to the SQL Server and prove this works.
Message posted via http://www.droptable.com|||InNeedOfAssistance wrote:
>I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
>that I have been unable to access the SQL Server on my laptop from another
>PC. When I go to register it from another PC I get:
>"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect())"
>The database is indeed running so I assume it must be some type of
>permission problem. Both PCs are in the same domain. I have tried to connec
t
>using Windows account information and SQL Server login information - both
>get the same error. I also tried to connect from another PC to the laptop
>with the same error. The laptop can see and access databases on each of
>these other PC's so it is just reading from the laptop that is not possible
.
>I did disable my Norton Internet Security to make sure that the firewall
>wasn't interferring but still get the same error.
>I'm pulling my hair out and could really use your help. Thanks for taking
>the time to read this.
Are you trying to login via Windows Authentication ? as the error message
seems that this login does not exist in the Security Logins. Do you have an
SQL Server ID you can just prove its Windows Auth with by logging in via tha
t?
Alternatively I have had the problem with OS's where it uses Netpipes by
default which are blocked by the network, to prove this create an ODBC with
IP /Port to the SQL Server and prove this works.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200704/1|||> Are you trying to login via Windows Authentication ? as the error message
> seems that this login does not exist in the Security Logins. Do you have
> an
> SQL Server ID you can just prove its Windows Auth with by logging in via
> that?
I tried to login with the sa account when I used SQL Server login
information and a login that I know is valid on my laptop for the Windows
account information login.
Probably another important piece of information that I didn't mention is
that when trying to register this database from another PC, it never is
displayed as one of the available databases. There is a NAME-LAPTOP database
that shows as available (I assume the default from installing Visual Studio)
but no NAME-LAPTOP\NAME_LAPTOP database as this one is called. I was
wondering if it might help to uninstall and reinstall SQL Server. Do you
know if there are ever any conflict between the Visual Studio db and the
main SQL Server db depending on install order? At this point, I don't
remember which I installed first. At one point, I had installed the Visual
InterDev on the laptop by accident but deleted that and installed Visual
Studio. I don't know if that could have messed anything up or not too.
Using Visual Studio on the laptop I can connect to the
NAME-LAPTOP\NAME_LAPTOP database but if I go to another PC I can't connect
using Visual Studio.

> Alternatively I have had the problem with OS's where it uses Netpipes by
> default which are blocked by the network, to prove this create an ODBC
> with
> IP /Port to the SQL Server and prove this works.
Do you mean create a script to see if I can login that way?.

> --
> Message posted via http://www.droptable.com
>|||Just to let you all know - the uninstall and reinstall of the database on my
laptop fixed all my problems. I'm sorry I didn't try that from the
beginning.

Cannot View My Database Diagrams

I recently reinstalled Visual Studio and SQL Server 2005 Developer Edition
onto a new (larger) hard drive and so far everything has been working as
before for my database, but when I went to view my database diagrams, I am
now getting this message. I tried as the message suggested to change the
database owner, but this only results in error messages. Neither can I add
any new database diagrams.
Anyone have any ideas as to how to solve such a problem?
Thanks,
Paul
---
TITLE: Microsoft SQL Server Management Studio
--
Database diagram support objects cannot be installed because this database
does not have a valid owner. To continue, first use the Files page of the
Database Properties dialog box or the ALTER AUTHORIZATION statement to set
the database owner to a valid login, then add the database diagram support
objects.What is the compatibility mode of the database?
You can check with:
select compatibility_level
from sys.databases
where name = 'YourDatabase'
It needs to be at 90 to use the diagrams. I think this was
fixed in the service pack so the other alternative is to
apply SP1.
-Sue
On Tue, 17 Oct 2006 08:37:01 -0700, a
<a@.discussions.microsoft.com> wrote:

>I recently reinstalled Visual Studio and SQL Server 2005 Developer Edition
>onto a new (larger) hard drive and so far everything has been working as
>before for my database, but when I went to view my database diagrams, I am
>now getting this message. I tried as the message suggested to change the
>database owner, but this only results in error messages. Neither can I add
>any new database diagrams.
>Anyone have any ideas as to how to solve such a problem?
>Thanks,
>Paul
>---
>
>TITLE: Microsoft SQL Server Management Studio
>--
>Database diagram support objects cannot be installed because this database
>does not have a valid owner. To continue, first use the Files page of the
>Database Properties dialog box or the ALTER AUTHORIZATION statement to set
>the database owner to a valid login, then add the database diagram support
>objects.
>--