Installing SQL Server 2005 Express on Windows 8 [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for … Read more

Who is your favorite European Windows web host provider? [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for … Read more

Weird TPS peaks on SQL 2005 replicated database

When monitoring the Transactions/Sec using perfmon on one of my SQL2005 replicated databases – I’m seeing the TPS increase to 1000 and then immediately drop back down again – this happens every 5 seconds. I’m not sure what’s causing this – is this something to do with replication? We also have asynchronous statistics set on … Read more

Access to the remote server is denied because no login-mapping exists

I’ve got a Linked Server in my SQL Express install that is using SQL Server Authentication. I’ve created a SQL Server login-mapping and it’s using Impersonate. I’ve confirmed that the account exists on both servers but I’m still getting the error. Any suggestions? Answer Where are you attempting to login from ? An application on … Read more

question about sql server (backup) [closed]

It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago. really I can not get what is back … Read more

How to configure a trusted connection between IIS 7 and SQL Server 2005?

How do configure a trusted connection between IIS 7 and SQL Server 2005? My webapp was working fine with Windows Authentication enabled in IIS. Now, in order to solve a problem, we need to use a trusted connection. Unfortunately, enabling the trusted connection in the web.config broke the webapp. Oddly enough, when I run this … Read more

SQL Server Express 2005 cannot accept connection (but ODBC working from external and local server)

I’m having a problem with SQL Server Express 2005 edition; it’s unable to be contacted from an application (3rd party monitoring utility software). I have perform the following tests, all of which succeeded: Ping and DNS resolve test from internal and external (my laptop). Creating System ODBC entry and then perform test from the server … Read more