0
votes
1answer
25 views

SQL Server Hardware Config

i am an IT Consultant and take up projects for my clients for setting up complete IT infrastructure. I have a client who has been facing problem with their DATABASE, he is a retail distributor for ...
0
votes
1answer
45 views

How can I troubleshoot an application connecting to SQL Server

I'm trying to get ASP.net StoreFront to Connect to SQL Server Express 2005, on Windows Server 2008. I followed This Microsoft Support article without success. Below is the error. [SqlException ...
1
vote
2answers
3k views

Add SSH host key to another user's PuTTY cache

I have written a PS1 script that 7-zips a file and uses PuTTY's SCP to store it at my back-up server. I have tested it and it works perfectly. Then I log into my SQL Server Agent and add an extra ...
-1
votes
1answer
766 views

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 ...
1
vote
2answers
7k views

Schannell: Certificate received from the remote server was issued by an untrusted certificate authoritythe

i'm not sure whether to ask this on dba.stackexchange.com or here. Periodically following error is logged in Windows Server 2008 Administrative events: The certificate received from the remote ...
0
votes
2answers
134 views

AWE turned on but still not using memory

I do have a server 2008 64 running a SQL server 2005. I do have 8GB on the server and I want SQL to use most of the memory on that server. I have turned the page-locking on for the account and also ...
0
votes
1answer
492 views

SQL Server blocking queries

My normal running SQL Server 2005 SP3 servers started experiencing random blocking issues over the past month. Each time it happens I run my blocking script to see whats blocking what (see code block ...
2
votes
3answers
206 views

HA suggestions for geographically separated sites

I have 6 instances of sql server that I need to be highly available by being hosted on two sites (one as principal, one as DR). Transparent automatic failover is required. Most are fairly boring and ...
0
votes
1answer
124 views

How to set the verbosity logging for SQL Server 2005 on Windows Server 2008 x64

I'm literally in tears right now because I can't find any way to turn up the verbosity of SQL Server 2005 logging. Does anyone know how to do this, because I'm about to shoot a hostage every hour on ...
4
votes
2answers
951 views

Log perfmon data to SQL Server

I am trying to log perfmon log (Windows Server 2008) to SQL Server 2005 (Windows Server 2003) using dsn (SQL Server authentication). On start perfmon counter i am getting error: "Call to ...
1
vote
2answers
45 views

Difference of speed if SQL Server is on one server and website is on another, rather than both on same server

We have db and website on same server. I would like to know that what would be the pros and cons of dedicated server for db (SQL Server 2005) and for website (webserver is IIS). Same db is also ...
0
votes
2answers
95 views

Migration Windows 2003->2008, SQL2005->2008

We have some servers with Windows 2003 and SQL Server 2005 and would like to upgrade them to Windows 2008 and SQL2008 because of the new cool features. How can that be done? Anything in particular to ...
2
votes
1answer
624 views

SQL Server 2008 Unique Problem for bring DB Online

This is my error I am facing TITLE: Microsoft.SqlServer.Smo Set offline failed for Database 'Go3D_Retailer ------------------------------ ADDITIONAL INFORMATION: An exception ...
2
votes
1answer
322 views

Sql 2005 Server 32 bit SPK3 CU3 on Windows 2008 64bit OS

What type of issues can I expect if I run Sql 2005 Server 32 bit SPK3 CU3 on Windows 2008 64bit OS. I'm really intrested to know if there are any known issues or tweaks with the configuration of ...
1
vote
2answers
47 views

MSSQL and Win Server issues - my problem, or host's?

I've been developing against SQL Server 2005 and my host-to-be supports windows server 2008. I understand that there are known issues with this combination, as well as resolutions/work-arounds. My ...
1
vote
2answers
3k views

“Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’.” to SQL Server 2005

I'm trying to migrate a legacy application we have to Windows Server 2008 x64 and IIS7. It's written in Classic ASP and connects to a SQL Server 2005 database. However, when the page runs, I receive ...
1
vote
2answers
996 views

Problem installing SQL Server client tools

We are tring to install SQL Server 2005 Standard on Windows 2008 Standard both 64 bit. Have done this before with no problems. This time we get an error during the installation of client tools: ...
1
vote
3answers
70 views

What is wrong if a dedicated SQL-Server 2005 on a win2003 Server creeps

i have a sql-server 2005 on a win2003 32-bit (3,5GB RAM) 4 CPU Server with a RAID 5 Disk-Array which perform at 1/10 of a virtual 2008-SQL-Server Win2008 32 Bit 2GB RAM Raid 5 Server. The Job is to ...
0
votes
2answers
120 views

SQL2K5 Standard to Enterprise upgrade

I have SQL2K5 Standard configured in an active/passive W2K8 cluster in my Production environment, and on a standalone box in my Staging environment. I want to upgrade to SQL2K5 Enterprise (mostly for ...
0
votes
3answers
9k views

How to allow access for a sql server user?

I am a developer-trying-to-play-admin and wish to connect to a remote sql server from my development machine using a sql server user ("op_web"). When I try to connect from vs2008 Server Explorer, I ...
2
votes
3answers
3k views

Run a SQL Server 2005 Job as Administrator on Windows Server 2008

I have a job, C:\foo.bat. When I run the job from windows explorer it fails. When I right click on the file and click "Run as administrator..." the job passes. Now when I setup the job in SQL ...
0
votes
3answers
184 views

Web App Performance Problem

I have a website that is hanging every 5 or 10 requests. When it works, it works fast, but if you leave the browser sit for a couple minutes and then click a link, it just hangs without responding. ...