Showing posts with label laptop. Show all posts
Showing posts with label laptop. Show all posts

Thursday, March 22, 2012

Can't add DataSource or connect to database with Wizard

Hi,

I installed Visual Studio 2005 Beta 2 and could connect with it to my SQL 2000 Server. Now I installed on the same laptop SQL Server 2005, but the installation failed on some error. Now I uninstalled SQL Server 2005, but now I can't connect anymore to any datasource. The "Add new Data Source" is just not highlited and the Wizard from Tools Menu "Connect to Database" does not launch at all.

Any one has a solution?

thanks,
ImmanuelThe solution was to repair the Visual Studio 2005 installation.

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.

Tuesday, March 20, 2012

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.

Can't access my own report

I am trying to access my report from my laptop. Both development computer
and a laptop are on the network with DC. I am using http://devcompip/reports
but I am getting prompted for the network password. I am trying to enter it
but it keeps prompting.
What's a problem?
Thanks for help.On Jun 22, 4:32 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
> I am trying to access my report from my laptop. Both development computer
> and a laptop are on the network with DC. I am usinghttp://devcompip/reports
> but I am getting prompted for the network password. I am trying to enter it
> but it keeps prompting.
> What's a problem?
> Thanks for help.
The most common reasons are:
- If you are using a non-IE browser, this may cause the problem.
- If you have the anonymous permissions setup on either the Reports or
ReportServer virtual directory in IIS. You may want to set up Windows
Authentication w/the standard IUSR_MachineName user and allow IIS to
control the password.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I once had another problem. My server was using DHCP and I had this happen
to me. I changed to a fixed IP address and everything was fine.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1182576182.834732.295990@.m36g2000hse.googlegroups.com...
> On Jun 22, 4:32 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
>> I am trying to access my report from my laptop. Both development computer
>> and a laptop are on the network with DC. I am
>> usinghttp://devcompip/reports
>> but I am getting prompted for the network password. I am trying to enter
>> it
>> but it keeps prompting.
>> What's a problem?
>> Thanks for help.
>
> The most common reasons are:
> - If you are using a non-IE browser, this may cause the problem.
> - If you have the anonymous permissions setup on either the Reports or
> ReportServer virtual directory in IIS. You may want to set up Windows
> Authentication w/the standard IUSR_MachineName user and allow IIS to
> control the password.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>