345 reputation
212
bio website
location Sydney, Australia
age
visits member for 2 years, 2 months
seen Mar 20 at 0:35

Jan
21
asked How to make SSAS Commit Write take less time
Jan
15
awarded  Tumbleweed
Jan
13
accepted How to create a server alias in SQL Server 2012
Jan
13
comment How to create a server alias in SQL Server 2012
Thanks @GreenstoneWalker
Jan
13
comment How to create a server alias in SQL Server 2012
Thanks for all the help Rob. One last question, and it's probably the bit that I've been missing, but do I need to set this up on my workstation that is connecting to the server, or on the server itself? I'm currently trying it just on the server which is what makes most sense to me, but I'm feeling I might have got that wrong
Jan
13
comment How to create a server alias in SQL Server 2012
I think I've just worked out what I'm missing. Do I need to setup the alias on the client computer? So my workstation needs the alias set up, not the SQL Server? Maybe I'm better off getting more IP addresses assigned to the server and doing it via DNS
Jan
13
comment How to create a server alias in SQL Server 2012
I've updated the question with some more info
Jan
13
revised How to create a server alias in SQL Server 2012
Added more info of what I've tried
Jan
13
comment How to create a server alias in SQL Server 2012
I think so. I've tried setting the server to "server,1544" and "server\system", I've tried setting the Port No to 1433 and 1544, I've done it for both 32 and 64 bit configurations, but I still get the same result
Jan
13
comment How to create a server alias in SQL Server 2012
ok, so I set server\System to listen on port 1544. If I connect to "server,1544" in SSMS it works, but if I connect to programdb it still connects to server\Live. What else do I need to setup?
Jan
13
comment How to create a server alias in SQL Server 2012
So the client can connect to the default port of 1433, but the alias redirects it to port XXXX? We can't specify the port for this program and we don't really want to change the default port of the Live database - too much to change.
Jan
13
comment How to create a server alias in SQL Server 2012
@AaronBertrand - not that I can see. It's not super helpful. Are aliases meant to allow you to handle this sort of thing? If I'm trying to do something impossible then we'll just install the 2nd NIC. It just feels like this should work.
Jan
13
comment How to create a server alias in SQL Server 2012
I did find some questions that were similar (eg. dba.stackexchange.com/questions/18451/…), however nobody seems to be reporting what I'm seeing
Jan
13
asked How to create a server alias in SQL Server 2012
Jan
8
asked Turn xact_Abort on for specific applications or user
Dec
11
comment What tables are affected by Change Data Capture
I've added some more info to the question which might make it a bit clearer. We're trying to find a particular range of lsn's across the database when we have no idea where they are
Dec
11
revised What tables are affected by Change Data Capture
added more info
Dec
11
comment What tables are affected by Change Data Capture
Sorry, I probably wasn't clear enough in the question. What I'm trying to find is for a given Lsn, which cdc tables have a record
Dec
11
asked What tables are affected by Change Data Capture
Oct
21
comment Error running Powershell Script in SQL Server Agent
Thanks, worked perfectly