I have two problems (I believe) My SQL Server Setup I installed the X 64 version of my Vista 64 Home Premium Box MSDN has installed SQL Server (the whole thing) from download. I had to work after running on many issues. This is a new box, so I have put it on a database that I have to work with another server. This also worked fine My first issue came when I tried to open a database in SQL Server Management Studio:
"Unable to find the requested net framework data provider. It can not be installed. System.Data) "
The box is not new and definitely .NET is installed (version 3 I believe). I found out that someone posted it as a bug but the team (SQL Server team) could not reproduce it, they removed it, I tried to install the recommended SP3 patch to no avail This is when I try to open a table to see the data (right-click and "open table"). I can also execute the query and get the result (from the inside of the management studio)
My second issue is that I can not connect to the server. I thought I could work around it (with questions), but I did not know that the ODBC connection was added to the box, only driver management studio can reach DB OK, but the machine does not believe that something on it Also, running at least default port (1433) and not, I do not have a named installation. It can not get SQL Server (under Control Panel)> Administrative Tools> Data Source (ODBC) while attempting to connect the DSN or any data source manually to the server. It appears as a registered database server under SQL Server Management Studio (I think it connects to the port of 1414, which I have heard? Not sure) This is my primary problem, and even so That if I can not open the tables (the first issue), then I need to be able to install it so that I connect it to it. The language source I'm connecting to is ColdFusion which is installed as a stand-alone server (IIS is not installed, it is not currently being used).
To connect to it, make sure that all services are running. Especially the SQL Server Agent.
In addition, check in the surface of SQL Server 2005 field configuration for services and connections. Check to see if the "Local and Remote" connections are active or not, under "Remote connections." It can be set to "local only"
Comments
Post a Comment