|
I'm on a WORKGROUP LAN at home, and I want to connect to an instance of SQL Server 2005 Express on one of the other boxes on the network. I have already enabled remote connections on that instance of SQL Server and restarted the service.
When I try to connect, it tells me this:
TITLE: Connect to Server<br />
------------------------------<br />
Cannot connect to HTPC.<br />
------------------------------<br />
ADDITIONAL INFORMATION:<br />
<br />
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)<br />
<br />
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
modified on Saturday, March 27, 2010 11:52 AM
|
|
|
|
|
Have you also enabled Named Pipes through the Configuration Manager?
|
|
|
|
|
Yeah.
Could it be a user account problem?
When I try to connect (using Windows Auth), it uses my local box's user account.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
Have you got Mixed Authentication set in the Sql Server Express instance? If so, can you connect using non-windows authentication?
I noticed that the message said that it can't find instance HTPC; Is that the name of the instance or is it HTPC\SQLEXPRESS?
|
|
|
|
|
i.j.russell wrote: Have you got Mixed Authentication set in the Sql Server Express instance? If so, can you connect using non-windows authentication?
No, but do I want to use non-windows authentication?
i.j.russell wrote: I noticed that the message said that it can't find instance HTPC; Is that the name of the instance or is it HTPC\SQLEXPRESS?
HTPC is the machine name. The server is HTPC\SQLEXPRESS.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
The reason for asking about mixed mode authentication is that if you can connect using a connectionstring like this;
Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;
but not like this;
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
then you do have a permissions issue. However, most connection problems are due to incorrectly naming the server or database. The more things we can discount, the easier it will be to fix.
|
|
|
|
|
This is almost a non-issue, as I have halfway decided to use SqlLite instead. Thanks anyway. 
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
Could someone help me with this one perhaps?
Let's say I have a simple SQL query like:
SELECT EmployeeID, EmployeeName, YearStarted FROM Employees
I'd like to return a fourth column in the result set of which the value is conditional upon the value of another column. For instance, if the value of YearStarted is older than 2007, return 'veteran' otherwise return 'spring chicken'.
I'm thining something like:
SELECT EmployeeID, EmployeeName, YearStarted, IF(YearStarted<2007,'Veteran','Spring Chicken') FROM Employees
but obviously such an IF statement doesn't exist in SQL. Is there another way to do it?
|
|
|
|
|
select
EmployeeID,
EmployeeName,
YearStarted,
case
when YearStarted < 2007 then 'Veteran'
else 'Spring Chicken'
end NewColumn
from
Employees
me, me, me
"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven
|
|
|
|
|
|
|
Wouldn't only string functions work? Just guessing.
|
|
|
|
|
Hi!
I was wondering what edition of SQL server i can install in win 7 ultimate!
Thanx.
|
|
|
|
|
I use SQL Server 2008, if that helps.
me, me, me
"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven
|
|
|
|
|
yeah i forgot to say sql 2008!
but what i meant was which edition? standard? enterprise? ....?
|
|
|
|
|
The OS has very little relevance of the edition you should use, it depends on your database requirements, This may help http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx[^]
If you are asking about a development environment then use either developer or express versions.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
For many years I have been using vb6 with Access Database as back end. In many cases while returning record sets Access is omitting the very first record and it returns the rest of the records. I am really baffled. Please help.
Hi all of you, I have corrected my mistake and got the answer for this question.
Here is how I got it solved. The records were stored with time field. When querying up I did not mention the begining of the starting day (like 00:01 - which implies the start time of the day) and the end of the day in the finishing date. (Thought up this solution very late.) And so I was getting a few records eliminated from the query result set.
Thanks for all of you who tried to help and you can consider my question closed.
Hope this helps somebody.
-- modified 1-Apr-16 12:47pm.
|
|
|
|
|
Are you confusing zero-based and one-based indexing for arrays?
Otherwise, showing some code might help us help you.
|
|
|
|
|
Whatever it returns first is the first. Or maybe you're using it wrong.
|
|
|
|
|
Dear,
Can anyone help me to make good database structure?
What i have are some locations where I have some machines. Every machines have 2 counters (IN and OUT). I need to be able to enter state of that counters and after that to compare that values with previous entry IN and OUT counters.
How I see it seams that somewere I need to keep information wich machine is on wich location. Beside that I need to track information about date and time of entries.
Situation:
Location 1 -> machine1, machine2, machine3
Location 2 -> machine4
Location 3 -> machine5, machine6, machine7, machine8
....
I need 3 kind of reports:
○ Deference between new IN / OUT and some old IN/OUT counters for every machine
○ Total IN/OUT for some location
○ Total IN/OUT for all location
How I need to organize this datas?
Thanks for helping me,
akioki
|
|
|
|
|
3 tables
Location
LocationID int identity(1,1)
Location varchar(20)
Machine
MachineID int identity (1,1)
LocationID int
Machine varchar(20)
TranTable
TranID identity (1,1)
MachineID
Direction
Date
This assumes a machine can have only 1 location and the machine can be checked in/out many times. Using a date on the transaction table will allow you to get durations, and state on a given date
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi All,
I am using SQL Server 2005. My problem is that I am unable to start MSSQL Server. When I go to services.msc, i found that the state of MSSQLServer is stopped. When I click on start, it gives me this error:
The SQL Server (MSSQLSERVER) service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts Service.
I try all possible things, google it and atlast re-install SQL Server but nothing happen. So please help me??
Thanks
|
|
|
|
|
Have you checked the event log to see if there are any messages relating to this in there?
me, me, me
"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven
|
|
|
|
|
2010-03-25 18:55:55.53 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2010-03-25 18:55:55.53 Server (c) 2005 Microsoft Corporation.
2010-03-25 18:55:55.53 Server All rights reserved.
2010-03-25 18:55:55.53 Server Server process ID is 2772.
2010-03-25 18:55:55.53 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG'.
2010-03-25 18:55:55.53 Server This instance of SQL Server last reported using a process ID of 212 at 3/25/2010 6:40:35 PM (local) 3/25/2010 1:10:35 PM (UTC). This is an informational message only; no user action is required.
2010-03-25 18:55:55.53 Server Registry startup parameters:
2010-03-25 18:55:55.53 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf
2010-03-25 18:55:55.53 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG
2010-03-25 18:55:55.53 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mastlog.ldf
2010-03-25 18:55:55.54 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-03-25 18:55:55.54 Server Detected 2 CPUs. This is an informational message; no user action is required.
2010-03-25 18:55:55.85 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2010-03-25 18:55:55.87 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-03-25 18:55:56.90 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-03-25 18:55:56.90 Server Database Mirroring Transport is disabled in the endpoint configuration.
2010-03-25 18:55:56.90 spid4s Starting up database 'master'.
2010-03-25 18:55:56.90 spid4s Error: 17207, Severity: 16, State: 1.
2010-03-25 18:55:56.90 spid4s FCB::RemoveAlternateStreams: Operating system error 6(The handle is invalid.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf'. Diagnose and correct the operating system error, and retry the operation.
2010-03-25 18:55:57.07 spid4s SQL Trace ID 1 was started by login "sa".
2010-03-25 18:55:57.09 spid4s Starting up database 'mssqlsystemresource'.
2010-03-25 18:55:57.24 spid4s Server name is 'MAC5'. This is an informational message only. No user action is required.
2010-03-25 18:55:57.24 spid9s Starting up database 'model'.
2010-03-25 18:55:57.24 spid9s Error: 17207, Severity: 16, State: 1.
2010-03-25 18:55:57.24 spid9s FCB::RemoveAlternateStreams: Operating system error 6(The handle is invalid.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\model.mdf'. Diagnose and correct the operating system error, and retry the operation.
2010-03-25 18:55:57.37 spid9s Clearing tempdb database.
2010-03-25 18:55:57.42 Server A self-generated certificate was successfully loaded for encryption.
2010-03-25 18:55:57.42 Server Error: 17182, Severity: 16, State: 1.
2010-03-25 18:55:57.42 Server TDSSNIClient initialization failed with error 0x7e, status code 0x60.
2010-03-25 18:55:57.42 Server Error: 17182, Severity: 16, State: 1.
2010-03-25 18:55:57.42 Server TDSSNIClient initialization failed with error 0x7e, status code 0x1.
2010-03-25 18:55:57.42 Server Error: 17826, Severity: 18, State: 3.
2010-03-25 18:55:57.42 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2010-03-25 18:55:57.42 Server Error: 17120, Severity: 16, State: 1.
2010-03-25 18:55:57.42 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
|
|
|
|
|
Yikes - wish I hadn't asked.
Okay, well, I'd be looking for the first reported error and concentrate on that:
Starting up database 'master'.<br />
Error: 17207, Severity: 16, State: 1.
Start with that and see how far you get. (If anyone else has a better suggestion now would be the time...)
me, me, me
"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
