• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

CorpGuy
#1 Posted : Tuesday, September 12, 2006 7:49:00 PM(UTC)
CorpGuy

Rank: Member

Joined: 1/17/2006(UTC)
Posts: 40

I am try to install BV5 on my laptop using SQL Server 2005 Developer(local installation). In the BV Site Manager's Drop Down List for SQL 2005 Server I dont see the name of my SQL Server("MYLAPTOP") when I click. I tried typing in "MYLAPTOP" in the DDL and get a popup saying "SQL 2005 Could Not be found on this computer".

In Microsoft SQL Server Management Studio I do see "MYLAPTOP" next to "Server Name" so I do think I have SQL Server 2005 installed correctly. Any ideas on how to fix my problem. Thanks.
Marcus
#2 Posted : Tuesday, September 12, 2006 8:01:51 PM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

Try ".\" as the server name which is SQL shorthand for localhost.
CorpGuy
#3 Posted : Tuesday, September 12, 2006 8:13:20 PM(UTC)
CorpGuy

Rank: Member

Joined: 1/17/2006(UTC)
Posts: 40

Hey Marcus,

I tried ".\" (it was in the DDL when I clicked) but no luck. Same error message. Any other ideas for me to look into?
Kman
#4 Posted : Tuesday, September 12, 2006 8:34:09 PM(UTC)
Kman

Rank: Member

Joined: 11/25/2003(UTC)
Posts: 370

Have you tested with management studio to make sure the server is up and running?
If so what are the connection parameters you used? Use the same for BV.
Did you give the install a named instance? If you did use .\WhateverYouNamedIt
Regards,
Kim(Kman) Rossey
www.toocoolwebs.com
BVSoftware - MerchantTribe Programming/Design, Database Programming and Business Applications
[email protected]
CorpGuy
#5 Posted : Tuesday, September 12, 2006 8:50:47 PM(UTC)
CorpGuy

Rank: Member

Joined: 1/17/2006(UTC)
Posts: 40

Kim,
To my knowledge(I just installed SQL Server 2005 Developer on my laptop today, so I still experiencing the learning curve) the server is up and running. I did View->Registered Servers and it show "MYLAPTOP" under Database Engine. I right click on MYLAPTOP and it shows it is started. As far as named instances, I dont recall doing so, how can I verify. Thanks.
Jeepaholic
#6 Posted : Wednesday, September 13, 2006 12:07:17 AM(UTC)
Jeepaholic

Rank: Member

Joined: 11/17/2003(UTC)
Posts: 2,051

Have you tried continuing the installation anyway? I know the beta version would erroneously flag that it could not find SQL Server, but would actually perform the install correctly if you just continued. Not sure if that's still the case in production or not.
CorpGuy
#7 Posted : Wednesday, September 13, 2006 8:49:14 AM(UTC)
CorpGuy

Rank: Member

Joined: 1/17/2006(UTC)
Posts: 40

Hmmm...I'm starting to wonder if I have the prod version of BV5. I have version 5.0.0.566. I downloaded it from the my shopping cart assuming it wasn't the beta.

As far as continuing with the install, the popup which says SQL Server cant be found on my machine, does not have any way of closing it( no OK button). I have been ending the task thru Windows Task Manager.
Nick Alberti
#8 Posted : Wednesday, September 13, 2006 9:12:31 AM(UTC)
Nick Alberti

Rank: Member

Joined: 9/27/2004(UTC)
Posts: 1,099

5.0.0.566 is the latest version.

If possible, can you reinstall SQL Server 2005? Pay attention to the Instance Name screen and Authentication Mode screen.

At the bottom of the page listed below, you'll find a "Site Manage Database Connection Help" link. Click on this link to view a screenshot of these two screens along with some other helpful info.

http://www.bvsoftware.co...rted/Site%20Manager.aspx
CorpGuy
#9 Posted : Wednesday, September 13, 2006 11:49:14 AM(UTC)
CorpGuy

Rank: Member

Joined: 1/17/2006(UTC)
Posts: 40

Nick,

I reinstalled SQL Server 2005 Developer and still get the same error. I set instance to default and Authentication Mode to Mixed. I attached screen prints of my problem. Thanks.
File Attachment(s):
BV5 Problem.doc (1,833kb) downloaded 214 time(s).

You cannot view/download attachments. Try to login or register.
Noah
#10 Posted : Wednesday, September 13, 2006 12:03:43 PM(UTC)
Noah

Rank: Member

Joined: 11/6/2003(UTC)
Posts: 1,903

Did you try \WALLYSLAPTOP as the SQL address?

How about 127.0.0.1

or go to the command prompt and do a ipconfig to see what your current IP is set to on your NIC and try that address.
Noah
CorpGuy
#11 Posted : Wednesday, September 13, 2006 12:42:34 PM(UTC)
CorpGuy

Rank: Member

Joined: 1/17/2006(UTC)
Posts: 40

Noah,
The first two suggestions gave me the same result.

I did the IPCONFIG and got the IP Address and keyed that in. It gave me the following error:

SQL Connection Error: A connection was successfully established with the server, but then an error occurred during the logon process.(provider:Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)



Do I need to enable Pipes somewhere in SQL Server? I thought Pipes were for remote access, and that Shared Memory was used when running the DB locally.

Thanks.
Jeepaholic
#12 Posted : Wednesday, September 13, 2006 1:02:28 PM(UTC)
Jeepaholic

Rank: Member

Joined: 11/17/2003(UTC)
Posts: 2,051

CorpGuy, do the following...I had an issue with connectivity the first time I installed MS SQL 2005 and it was because Dynamic Ports were turned on by default. Not sure if this'll help you at all, but it might:

Open up: SQL Server Configuration Manager

Expand: SQL Server 2005 Network Configuration

Highlight: Protocols for <instancename>

Right-click, select properties for: TCP/IP

Select tab: IP Addresses

It *used* to be set up where each IP listed (and the IPAll section), all had the TCP Dynamic Ports set to 0 (zero), and the TCP Port is blank.

I now have it set up where all the sections have the TCP Dynamic Ports as blank, and the TCP Port as 1433 (standard SQL port)

Hopefully this might help...
CorpGuy
#13 Posted : Wednesday, September 13, 2006 1:29:37 PM(UTC)
CorpGuy

Rank: Member

Joined: 1/17/2006(UTC)
Posts: 40

Al,
My settings seem to be setup that way already. I have the following:
IP1
Active - Yes
Enabled - No
IP Address - 192.168.0.102
TCP Dynamic Ports - blank
TCP Port - 1433
IP2
Active - Yes
Enabled - No
IP Address - 127.0.0.1
TCP Dynamic Ports - blank
TCP Port - 1433
IPAll
TCP Dynamic Ports - blank
TCP Port - 1433

Thanks.
CorpGuy
#14 Posted : Wednesday, September 13, 2006 3:14:31 PM(UTC)
CorpGuy

Rank: Member

Joined: 1/17/2006(UTC)
Posts: 40

Noah,

Your last suggestion pointed me in the right direction.

I went into SQL Server Configuration Manager and enabled "Named Pipes" under "Protocols for MSSQLSERVER". The BV Site manager then created my store.

I'm still confused why SQL Server 2005 Developer has it "Named Pipes" disabled for a default. I would think that more people would have had trouble with this when creating a store.

Many thanks to everyone for their replys.
Kman
#15 Posted : Wednesday, September 13, 2006 3:52:46 PM(UTC)
Kman

Rank: Member

Joined: 11/25/2003(UTC)
Posts: 370

MS is doing this on most server applications now for security. Disable unless needed.
Regards,
Kim(Kman) Rossey
www.toocoolwebs.com
BVSoftware - MerchantTribe Programming/Design, Database Programming and Business Applications
[email protected]
Noah
#16 Posted : Wednesday, September 13, 2006 4:00:05 PM(UTC)
Noah

Rank: Member

Joined: 11/6/2003(UTC)
Posts: 1,903

CorpGuy I hear what you're saying but as Kman mentioned above with the new MS aproach it's better to have it locked down requiring a user to enable specifically what they want instead of leaving the machine wide open.
Noah
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012