3
votes
1answer
252 views

Cannot connect to SQL Server 2012 Express instance outside a VM

I'm trying to connect to a SqlServer instance - located in my host machine - from my VM, using Sql Server Management Studio. From my host I can connect to both SQL instances using SSMS, but when I ...
1
vote
1answer
28 views

Find out what is using SQL installations on a Windows Server

I have taken over a server that has tons of SQL Server related bits installed, and as far as I know, there are no applications on the server requiring the use of SQL. There are different SQL Server ...
1
vote
2answers
54 views

Automating the creation of SQL servers

VMWare has a tool called vFabric Data Directory which allows you to automate building SQL, Postgress and Oracle servers using VMWare. Is there something simular to this that will work for Hyper-V? I ...
4
votes
1answer
5k views

Can MS SQL Management Studio 2012 be installed without installing SQL SERVER?

We have a windows server 2012 with SQL Server 2012 BI installed. I can remote desktop and use the sql management studio in the server. However I would like to install that tool - sql management ...
1
vote
1answer
123 views

SQL Server + Windows Server CALs [duplicate]

Possible Duplicate: Can you help me with my software licensing issue? I've asked the same question on stackoverflow, but i think it suits here better since it's a problem not related to ...
1
vote
2answers
10k views

SQL Server 2012: I can connect locally but not remotelly

I'm trying to access a SQL Server 2012 database from a SQL Server Management Studio 2008 from a remote machine(on the same LAN). I can connect to the database using "sa" user under ...
1
vote
2answers
450 views

Best practice for instaling multiple instances of MS SQL 2008r2 on Windows server 2008r2 (running on esxi)

I wann't to move my sql server onto virtualized platform (Vsphere, esxi 4.1). Here is my plan on how would I install it: Vm with 3 disk's. C: for windows and sql binaries, D: for sql data, E: for ...
1
vote
3answers
781 views

“Incorrect syntax near '='” error when saving database connection settings during phpBB installation

I'm trying to install phpBB, and all I need is a working SQL database w/ login etc. I have tried using mySQL and it wouldn't let me change the password (I guess this is a common issue) so now I'm ...
0
votes
6answers
1k views

Setting up a network e-mail server

My boss just asked me to buy a new server for our office network. I know next to nothing about servers and networking, so I need someone to point me in the right direction. He said he wants this to ...
3
votes
1answer
1k views

Are there problems teaming the public network adapters on a Windows Server 2008 R2 failover cluster?

We have a two-node Windows Server 2008 R2 fail-over cluster that's hosting about a dozen instances of SQL Server. The nodes each have four network adapters in them (a pair of dual-port Broadcom ...
0
votes
1answer
241 views

Load Balancing and High Availability for Web Site

We've developing a database driven (70%/30% read/write load) website using C#.NET, IIS and MS SQL Server 2008 to be hosted on Windows 2008. Due to contractual reasons our setup has to be hosted on our ...
0
votes
0answers
593 views

Windows Server 2008 / SQL 2008 Licensing for Authenticated Web Application [duplicate]

Possible Duplicate: Can you help me with my software licensing question? I'm trying to crunch some numbers to see what the software costs involved are for hosting an application we are ...
1
vote
1answer
171 views

Remote login to SQL Server Express 2008

I am trying to remotely access MS SQL Server Express 2008. I have turned on service "SQL Server Browser" I have turned on service "SQL Server (SQLExpress)" I have enabled TCP/IP and set dynamic ...
0
votes
2answers
150 views

Recommended settings for 2-tier server environment

I'm trying to setup a 2-tier server environment in Windows Server 2008, which I'm finding is a little different from XP or Server 2003. The web tier is using IIS and ASP.NET 3.5 and the database tier ...