Thakur

Mumbai, India

narliagripada.com

Age: 26

I'm Aamod. I am located in Mumbai,India and currently working as a Project Manager, Sr. Project Programmer and Database Administrator. My interests span all aspects of design and development, including ASP.NET, AJAX, SQL Server, C#, VB.NET and everything in between.I love working on Microsoft Products and Technologies like Visual Studio,SQL Server, Windows 7,etc

Microsoft Certified IT Professional - Database Administrator

Microsoft Certified Technology Specialist-SQL SERVER 2005

Nov
15
awarded Famous Question
Nov
7
awarded Notable Question
Oct
16
awarded Popular Question
Sep
28
awarded Yearling
Apr
10
accepted Detect if SQL Connection is using Alias (Configuration Manager)
Apr
10
comment Detect if SQL Connection is using Alias (Configuration Manager)
Well I know and was trying to find if any alternative is available, Network team wanted this to be implemented at the Application Layer. Thank you.
Apr
10
comment Detect if SQL Connection is using Alias (Configuration Manager)
Basically I want to restrict Winforms Application Login only to LAN. If a user tries to connect to a server over internet, it should not be allowed. BUT we dont want to do it using Firewall policies or SQL Logon Triggers. We have handled the connections if it is using hosts file. Now we need to take care of Aliases
Apr
10
comment Detect if SQL Connection is using Alias (Configuration Manager)
Sorry if that was not clear. Please check edit "(basically i want to know the actual IP address of the Server that the client is using". I want the IP address of the server that client is using to connect.
Apr
10
revised Detect if SQL Connection is using Alias (Configuration Manager)
added 14 characters in body
Apr
10
comment Detect if SQL Connection is using Alias (Configuration Manager)
Hello @Remus, I want to detect the Server Value entered in the SQL Native Client Alias. So Basically in above example, the output i want is 10.10.10.10\MYSERVER or 10.10.10.10 i.e. the actual public IP of the SQL server to which client is connecting using Alias.
Apr
10
comment Detect if SQL Connection is using Alias (Configuration Manager)
When i run above query from client, it gives me local IP of the server. What i want is the IP used by the Client (connecting over internet) to Connect to the SQL Server.
Apr
10
comment Detect if SQL Connection is using Alias (Configuration Manager)
@MarcGravell, Yes @@ServerName is not usable. It will be fine if we are able to detect it at .NET or SQL level. Any ideas?
Apr
10
comment Detect if SQL Connection is using Alias (Configuration Manager)
@CodeCaster, Datasource property returns back CRM_APP. But the output i am expecting is the Server mentioned in Alias i.e. 10.10.10.10\MYSERVER mentioned in this example.
Apr
10
comment Detect if SQL Connection is using Alias (Configuration Manager)
I want to detect it on client for login event. Also it would be Ok if it is detected on Server, i can read back the data to client using SQL query if needed.
Apr
10
asked Detect if SQL Connection is using Alias (Configuration Manager)
Feb
18
comment SQL query getting Server name in triggers when using ASP.NET
You wont be able to do it in web.config, its not recommended either. check : stackoverflow.com/questions/3441774/…
Feb
18
answered SQL query getting Server name in triggers when using ASP.NET
Feb
11
awarded Notable Question
Sep
28
comment Find First check number in Quickbooks using QBFC
I want to get last generated check number for a specific account. This field is mentioned in QB On Screen Reference: AccountQuery IncludeRetElementList but I and unable to retrieve the LastCheckNumber using ACcountQuery. Can you please help?
Sep
26
awarded Popular Question
1 2 3 4 5