P
Peter Lux
I'm fairly new to c#, but not new to programming. I'm tasked with rewriting
our Gupta/Sqlwindows apps (5 years worth of development) in dot Net. The
main reason is that virtually no one knows the language, which is
unfortunate because it's very simple to get windows created and rolled out.
I downloaded C# (orcas) express and had created a SqlServer 2005 database
(locally, ie not on a server) and moved some of our production data into it
just to see if I could start coding some of the "simpler" tables. I'm not
planning on using express in the long run, I'm just evaluating the software
at this point.
I can't connect to the database. When I go to Database Explorer and clik on
Data Connections, I fill in the dialog with the .mdf that I want to attach
to. It comes back with
"...When connection to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: SQL Network Interfaces, error: 26- Error Locating
Server/Instance Specified)"
I've checked to see that remote connections are specified and that I have
the correct protocols enabled. I can attach and query the tables in SQL
Server Management Studio 2005 just fine.
What, perhaps, am I doing wrong?
our Gupta/Sqlwindows apps (5 years worth of development) in dot Net. The
main reason is that virtually no one knows the language, which is
unfortunate because it's very simple to get windows created and rolled out.
I downloaded C# (orcas) express and had created a SqlServer 2005 database
(locally, ie not on a server) and moved some of our production data into it
just to see if I could start coding some of the "simpler" tables. I'm not
planning on using express in the long run, I'm just evaluating the software
at this point.
I can't connect to the database. When I go to Database Explorer and clik on
Data Connections, I fill in the dialog with the .mdf that I want to attach
to. It comes back with
"...When connection to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: SQL Network Interfaces, error: 26- Error Locating
Server/Instance Specified)"
I've checked to see that remote connections are specified and that I have
the correct protocols enabled. I can attach and query the tables in SQL
Server Management Studio 2005 just fine.
What, perhaps, am I doing wrong?