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?
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
"mmoon" <anonymous@.discussions.microsoft.com> wrote in message
news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
> 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?
|||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
"mmoon" <anonymous@.discussions.microsoft.com> wrote in message
news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
> 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?
|||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
>"mmoon" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
Community[vbcol=seagreen]
using[vbcol=seagreen]
2000[vbcol=seagreen]
database[vbcol=seagreen]
creat[vbcol=seagreen]
to[vbcol=seagreen]
System[vbcol=seagreen]
am.
>
>.
>
|||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
>"mmoon" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
Community[vbcol=seagreen]
using[vbcol=seagreen]
2000[vbcol=seagreen]
database[vbcol=seagreen]
creat[vbcol=seagreen]
to[vbcol=seagreen]
System[vbcol=seagreen]
am.
>
>.
>
|||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
<anonymous@.discussions.microsoft.com> wrote in message
news:2283801c45d41$8d809c50$a401280a@.phx.gbl...[vbcol=seagreen]
> 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.
>
> are you trying to
> try?
> message
> Community
> using
> 2000
> database
> creat
> to
> System
> am.
|||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
<anonymous@.discussions.microsoft.com> wrote in message
news:2283801c45d41$8d809c50$a401280a@.phx.gbl...[vbcol=seagreen]
> 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.
>
> are you trying to
> try?
> message
> Community
> using
> 2000
> database
> creat
> to
> System
> am.