Viewing 14 posts - 1 through 14 (of 14 total)
Just to make things more interesting, when I ran
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
I got the following results:
10.0.2531.0SP1Standard Edition (64-bit)
But when I opened C:\Program Files\Microsoft SQL Server\100\Setup...
November 5, 2009 at 7:15 am
Is your instance in mixed mode for security? Because if not, you will be able to add SQL logins all day long and still not be able to connect.
...
November 3, 2009 at 10:20 am
So by application you are talking about Winform users SQL Server access there are two options one you add all the users manually into SQL Server, if your application...
November 3, 2009 at 9:11 am
I know that you said that port 1433 is not being blocked on the 2008 machine, but have you tried taking the firewall out of the equation altogether? Can you...
November 2, 2009 at 10:40 pm
What about applications (*.exe)? They will more than likely to either use ODBC or ADO .NET.
November 2, 2009 at 10:37 pm
Moving away from Sharepoint, I still have aproblme of a 2008 machine not being able to connect to a 2008 sql server. Eventually, many of the project databases...
November 2, 2009 at 5:10 pm
Although I'm testing on a machine that will be hosting sharepoint I just want to make sure that other 2008 machines that would not be hosting sharepoint sites but other...
November 2, 2009 at 1:36 pm
I also want to state again, I have no problems connecting to a 2005 SQL Server from a windows 2008 machine.
November 2, 2009 at 9:30 am
Now your connection is Windows passing permissions to SQL Server when you have not defined any permissions in SQL Server.
I am sorry for not stating this before: the two test...
November 2, 2009 at 9:29 am
The best security is careful planning and applying relevant needed permissions not removing management tools because you think management tools creates security risk.
Management tools were not installed on the is...
November 2, 2009 at 9:13 am
There are no such tools installed on these machines.
November 1, 2009 at 2:43 pm
I'm using a small test program I created using C#. It basically tries to open and close a SQL Connection using windows authentication and sql server authentication.
It's...
November 1, 2009 at 12:37 pm
Just to be clear, the client Windows 2008 and Windows 7 machines' firewalls have to be configured to allow requests sent out from those machines? The 1433 port on...
November 1, 2009 at 12:22 pm
SQL Server 2008 Standard License + Software Assurance Only. The license was applied to a 180-day trial version. Correctly, the machine that has SQL Server is for internal access...
October 2, 2009 at 10:42 am
Viewing 14 posts - 1 through 14 (of 14 total)