435 reputation
37
bio website
location
age
visits member for 2 years, 5 months
seen Jul 16 at 20:52

Jul
7
comment Windows Authentication Doesn't Work Locally
I've added a screenshot. Thanks.
Jul
2
comment Windows Authentication Doesn't Work Locally
My password hasn't expired. We've tried multiple Windows accounts and they all get the error. I even created a new local user on the box, gave it db access and it gets the error. The domain accounts with access all work as long as we're connecting to the db on HP00333198 from another machine.
Jul
1
comment Windows Authentication Doesn't Work Locally
Yes, it is definitely running. I can connect using SQL authentication, just not Windows authentication. Windows authentication works if I'm connecting FROM another machine.
Jun
13
comment Linked Server to Mirrored Database Fails
I think I'm out of luck using Windows Authentication because the mirrored servers are in a different untrusted domain from the server with the linked server. And, hardcoding the sql username and password is what I was trying to do and doesn't work (except on that one SQL Server Express instance in the same untrusted domain.
Jun
13
comment Linked Server to Mirrored Database Fails
Thanks. I've also tried stopping the SQL Server service on Server1 and then trying the linked server. It just gives a single "Msg 11001, Level 16, State 1, Line 0 TCP Provider: No such host is known." error. It still doesn't attempt a connection to the FailoverPartner.
Jun
12
comment Linked Server to Mirrored Database Fails
I'm not sure if this what you're asking, but if I run "nslookup Server1" or "nslookup Server2", it gives me their ip addresses. Since I can get Server2 to work if I make it the primary in the provider string, I don't think it's an issue with connectivity. I just seems like the linked server won't try the FailoverPartner.
Jun
12
comment Linked Server to Mirrored Database Fails
Yes, just mirroring. After I've failed over to Server2, I can ping both Server1 and Server2 from Server3 (the one that has the linked server).
Nov
21
comment Searching for pairs of date/time values in a single row
@Sam, in the 1st code bock, if the start/stop days are the same, the 2nd condition and the 3rd condition combined will return ALL rows for the day. Say the start time was 3p (150000) and the stop time was 5p (170000), the 2nd condition would return everything from 3p to 11:59:59p (150000 thru 235959) and the 3rd condition would return everything from midnight (000000 to 170000). Since the 2nd and 3rd conditions are OR'd, you get everything. That's the basic difference between the two code blocks. The 1st one is OR'd and the 2nd one is AND'd.
Nov
20
comment Another BCP Export [Fail]ure
@Killercam, could you use global temp tables (e.g. ##TmpTableColumnNames)?
Nov
20
comment Searching for pairs of date/time values in a single row
@Sam, I'm pretty sure you need both cases. I only had the second case and somebody pointed out that it will return all rows for a day if the start and stop days are the same.
Nov
20
comment Searching for pairs of date/time values in a single row
@ChrisAldrich, I'm not familiar with the db2 syntax. Those are supposed to be variables.
Oct
19
comment Altering nullability of column in SQL Server
I would guess that going from NOT NULL to NULL works because every value stored in a column defined as NOT NULL is allowed if the definition is changed to NULL. The opposite is not true. Not every value stored in a nullable column will be allowed in a non-nullable column.
Oct
10
comment How do I write portable SQL that refers to a linked server?
If you took this approach, I think I'd wrap the CASE statement in a function so if a server changed, I'd only have to update the function.
Aug
8
comment Can I move data and full text search files to another drive and change the drive letter?
Seems to have worked perfectly. Thanks!
Aug
8
comment Can I move data and full text search files to another drive and change the drive letter?
We don't have enough drive/space on the dev server to test. However, this is a standby server for production. The main production server already has a large G:\ drive. Thanks for the permissions tip. I'll use xcopy with /O /X /E /H /K.
Aug
8
comment Can I move data and full text search files to another drive and change the drive letter?
SQL Server 2005 Enterprise Edition. As for the reboot, I figured it couldn't hurt.
Feb
9
comment SQL Server Linked Server Permissions
Thanks for all the help. Tried Attempt #2, but still no luck. It's got to be SQL Server permissions issue. The query works if my user (a sql authenticated user) is a member of the System Administrators role. It fails if the user is not.
Feb
7
comment SQL Server Linked Server Permissions
Thanks, but "Show Advanced Options" was already set to 1 and "Ad Hoc Distributed Queries" doesn't exist in SQL 7.
Feb
7
comment SQL Server Linked Server Permissions
The service account for MSSQLServer is just a generic domain account we user for our SQL servers. The non-SA user (testuser) is using SQL auth. If I just make testuser a SA, it works, so I know it's just a permission issue.