Forum Replies Created

Viewing 15 posts - 61 through 75 (of 337 total)

  • RE: 3rd party Application security issues

    runaldo,

    Thanks for the reply.

    I'm a little confused as to why each user is created with those rights yet they aren't mapped to any database. I also can't login to...

  • RE: 2008 R2 Browser Service Disabled

    Thanks for the replies.

    I was looking in the SQL Server Configuration manager where you can't enable that service so I wasn't sure. I did enable it through Windows Services though.

    I've...

  • RE: ODBC Cannot generate SSPI Context

    MM,

    I was able to get the DSN to work with our application locally and remotely. We prompt the user for their username/password and use that to login. It works well...

  • RE: ODBC Cannot generate SSPI Context

    MM,

    Again thanks for the reply.

    The application already has one DSN-less connection string that connects to our DB for doing other stuff. That connection string has the username and password supplied...

  • RE: ODBC Cannot generate SSPI Context

    I've tested the DSN with various settings.

    The DSNs use:

    SQL Server Driver

    For the server I've used Public or Internal IP addresses and FQDNs depending if I'm local or not. All...

  • RE: ODBC Cannot generate SSPI Context

    I downloaded the Native Client 10.0 and used it but no luck.

    I can't connect to our DB using a DSN within our application unless we're on the same...

  • RE: ODBC Cannot generate SSPI Context

    SQL Server is the only driver available. I see I can download the Native Client and it does work with SQL 7.0, 2000 and 2005... at least this version does:...

  • RE: ODBC Cannot generate SSPI Context

    mister.magoo,

    Thanks for the reply.

    If you mean what protocol (provider) I'm using... I am using TCP/IP unless you're referring to ODBC which we are using. Not sure if I'm understanding you...

  • RE: Login failed for user '(null)'

    Rachel,

    Did you ever find a solution to this problem? I have an application that uses a User DSN to connect to a remote DB and we get the same error....

  • RE: Can't Replace Blank Value on a NVARCHAR

    yeah It's not clean b/c when I try to do some calculations on it it fails after I try converting it to a decimal or int. I have a function...

  • RE: Can't Replace Blank Value on a NVARCHAR

    Ninja's_RGR'us (1/7/2011)


    UDPATE T SET Weight1 = '0' from dbo.tTable1 WHERE Weight1 = ''

    Also it might be worth it to convert that column to an integer or decimal. Then keep...

  • RE: Can't Replace Blank Value on a NVARCHAR

    steveb,

    Thanks for the reply. Well that explains it. My BOL doesn't say anything about that in the Replace String Function command explanation. Go figure.

  • RE: Risk Analysis

    DR and BCP has been a huge focus for us this year. We started this earlier in the year and our project is still not 100% complete. I think from...

  • RE: RS 2008 Installation

    Okay.. so I dug into the Books Online which was pretty useful.... but it doesn't suggest any "best practice" from what I can tell.

    It appears RS has it's own...

  • RE: SQL Server Failover solutions

    _taz_

    Also it's not always just about failover it's about failback too. Some products take a long time to failback to the primary server which isn't always acceptable.

Viewing 15 posts - 61 through 75 (of 337 total)