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.
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Try ".\" as the server name which is SQL shorthand for localhost.
|
|
|
|
|
|
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?
|
|
|
|
|
|
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 |
|
|
|
|
|
|
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.
|
|
|
|
|
|
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. |
|
|
|
|
|
|
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.
|
|
|
|
|
|
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 |
|
|
|
|
|
|
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.
|
|
|
|
|
|
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 |
|
|
|
|
|
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.
|
|
|
|
|
|
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... |
|
|
|
|
|
|
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.
|
|
|
|
|
|
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.
|
|
|
|
|
|
Rank: Member
Joined: 11/25/2003(UTC)
Posts: 370
|
MS is doing this on most server applications now for security. Disable unless needed. |
|
|
|
|
|
|
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.