Can not create a database in VS.Net using SQL  
Author Message
PBear





PostPosted: Mon Jun 28 13:01:36 CDT 2004 Top

SQL Server >> Can not create a database in VS.Net using SQL

I am taking a course in ASP.Net at Finger Lakes Community
College. I am trying to create a database in VS.Net using
SQL. In the computer lab we have the class in I can
create a database in VS.Net using SQL. In the open lab
and at home on my P.C. I have VS.Net and SQL Server 2000
loaded. Every is the same BUT I cannot create a database
using SQL on my P.C. or in the open lab. I am set up as
the administrator and have all the rights I need to creat
a database. The permissions are the same from one lab to
the other and on my P.C. and the server is on. My System
Admininstrator and Teacher are just as confused as I am.
We need to resolve this issue before the start of the
fall semester. Does anyne have an idea on why this is
happening?

SQL Server201  
 
 
Andrew





PostPosted: Mon Jun 28 13:01:36 CDT 2004 Top

SQL Server >> Can not create a database in VS.Net using SQL Please be a bit more clear as to what is happening. How are you trying to
create the database? What error are you getting when you try?

--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company


> I am taking a course in ASP.Net at Finger Lakes Community
> College. I am trying to create a database in VS.Net using
> SQL. In the computer lab we have the class in I can
> create a database in VS.Net using SQL. In the open lab
> and at home on my P.C. I have VS.Net and SQL Server 2000
> loaded. Every is the same BUT I cannot create a database
> using SQL on my P.C. or in the open lab. I am set up as
> the administrator and have all the rights I need to creat
> a database. The permissions are the same from one lab to
> the other and on my P.C. and the server is on. My System
> Admininstrator and Teacher are just as confused as I am.
> We need to resolve this issue before the start of the
> fall semester. Does anyne have an idea on why this is
> happening?


 
 
anonymous





PostPosted: Mon Jun 28 13:56:00 CDT 2004 Top

SQL Server >> Can not create a database in VS.Net using SQL I start VS.Net and open a new project for ASP.Net. I then
go to Server Explorer and right click on Data Connections
and select Create a new SQL Database. In the window where
you enter the server I type in the local server's name
and then type in the name of the database I want to
create. It may take a moment or two but I'll get an error
message stating "Can not create a databse on this
server". when I check the permissions in Enterprise
Manager I see that all the permissions are set for me to
e able to create a database.


>-----Original Message-----
>Please be a bit more clear as to what is happening. How
are you trying to
>create the database? What error are you getting when you
try?
>
>--
>Andrew C. Madsen
>Information Architect
>Harley-Davidson Motor Company

message

>> I am taking a course in ASP.Net at Finger Lakes
Community
>> College. I am trying to create a database in VS.Net
using
>> SQL. In the computer lab we have the class in I can
>> create a database in VS.Net using SQL. In the open lab
>> and at home on my P.C. I have VS.Net and SQL Server
2000
>> loaded. Every is the same BUT I cannot create a
database
>> using SQL on my P.C. or in the open lab. I am set up as
>> the administrator and have all the rights I need to
creat
>> a database. The permissions are the same from one lab
to
>> the other and on my P.C. and the server is on. My
System
>> Admininstrator and Teacher are just as confused as I
am.
>> We need to resolve this issue before the start of the
>> fall semester. Does anyne have an idea on why this is
>> happening?
>
>
>.
>
 
 
Andrew





PostPosted: Tue Jun 29 14:46:17 CDT 2004 Top

SQL Server >> Can not create a database in VS.Net using SQL Ok. Are you using SQL Authentication? Is the server in the open lab in the
same domain as your PC? Is the SQL Server and the home PC in the same
domain? VS.net will not move across domains.

--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company


> I start VS.Net and open a new project for ASP.Net. I then
> go to Server Explorer and right click on Data Connections
> and select Create a new SQL Database. In the window where
> you enter the server I type in the local server's name
> and then type in the name of the database I want to
> create. It may take a moment or two but I'll get an error
> message stating "Can not create a databse on this
> server". when I check the permissions in Enterprise
> Manager I see that all the permissions are set for me to
> e able to create a database.
>
>
> >-----Original Message-----
> >Please be a bit more clear as to what is happening. How
> are you trying to
> >create the database? What error are you getting when you
> try?
> >
> >--
> >Andrew C. Madsen
> >Information Architect
> >Harley-Davidson Motor Company

> message

> >> I am taking a course in ASP.Net at Finger Lakes
> Community
> >> College. I am trying to create a database in VS.Net
> using
> >> SQL. In the computer lab we have the class in I can
> >> create a database in VS.Net using SQL. In the open lab
> >> and at home on my P.C. I have VS.Net and SQL Server
> 2000
> >> loaded. Every is the same BUT I cannot create a
> database
> >> using SQL on my P.C. or in the open lab. I am set up as
> >> the administrator and have all the rights I need to
> creat
> >> a database. The permissions are the same from one lab
> to
> >> the other and on my P.C. and the server is on. My
> System
> >> Admininstrator and Teacher are just as confused as I
> am.
> >> We need to resolve this issue before the start of the
> >> fall semester. Does anyne have an idea on why this is
> >> happening?
> >
> >
> >.
> >