Help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Help

Author

Topic

fatalbert
Starting Member

9 Posts

Posted - 2006-01-27 : 04:56:33

I'm new to SQL Server.

When I run my web page application through Visual Studio it opens ASP.NET Developers Server and an arbitrary port. The connection to MSS works fine.

But when I try to veiw it through IIS (localhost) a get the message "Login failed for user".

Why dosen't it work on IIS?

Edit: I put the TCP/IP to "enabled" in the configuration manager, but the error is still there.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-01-27 : 07:52:06

Welcome to SQLTEAM

one question. Did you give permissions to the user ?

Norwich
Posting Yak Master

158 Posts

Posted - 2006-01-27 : 10:43:30

You might want to post this on an ASP Forum

N

The revolution won't be televised!

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-01-27 : 12:06:38

quote:
Originally posted by Norwich

You might want to post this on an ASP Forum

N

The revolution won't be televised!

I think its kind of mixed

fatalbert
Starting Member

9 Posts

Posted - 2006-01-27 : 12:28:57

quote:
Originally posted by afrika

Welcome to SQLTEAM

one question. Did you give permissions to the user ?

Thank you!

Don't think so. I'm really a beginner at this. Don't know how I can create userers and give them permissions. I don't seem to have any application for managing SQL Server. Tried to Google on the subject, but can't figure it out. Is it Enterprise Manager I should install?

fatalbert
Starting Member

9 Posts

Posted - 2006-01-27 : 12:29:56

quote:
Originally posted by Norwich

You might want to post this on an ASP Forum

N

The revolution won't be televised!

I think it's SQL Server or IIS related, but I'm not sure.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-01-27 : 13:27:27

I would advice you get a book
http://www.sqlteam.com/store.asp

And also a book on dynamic driven websits using .net do a search on amazon, there is a lot to learn

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-01-27 : 13:30:15

But on the interim, read up on creating permission in SQL server and access to objects

fatalbert
Starting Member

9 Posts

Posted - 2006-01-27 : 13:41:32

quote:
Originally posted by afrika

I would advice you get a book
http://www.sqlteam.com/store.asp

And also a book on dynamic driven websits using .net do a search on amazon, there is a lot to learn

I've resently bought "Professional ASP.NET 2.0" and "Transact-SQL Desk Reference" so I'm sincer in my intents. Perheps my next book will be on SQL Server, but right now I want to solve this problem so I can get on developing my web page.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-01-27 : 13:56:09

Ok good.

I guess thats wrox publications, i like them cos they are good. There should be a part where they talk about databases and permissions ?

You need to grant permissions to your database users. check this

1. Open Em
2. Check to see the users under security
3. Open your db, and see the users there as well.

Basically you would have to create a user, and add him to your db.

And all objects accessed need to be granted permissions. Open books online and read up on this

tables, views have to be granted , select, update, insert and delete

while Sp have to be granted execute

Understand ?
Afrika

fatalbert
Starting Member

9 Posts

Posted - 2006-01-27 : 14:15:06

I think I understand and thank you for trying to help me.

When you write "Open Em" do you mean open Enterprise Managare? The problem is that I don't have it.

I read some in my book just now and saw that I grant premission using SQL. Had not understood this untill now. These premission are granted on a security accont, right? So the question is: how do a create a sequrity accont (XP pro)?

Thanks again for helping me and I'm sorry I'm so slow.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-01-27 : 14:22:04

first question

Do you have MS SQL installed ?

fatalbert
Starting Member

9 Posts

Posted - 2006-01-27 : 14:25:19

quote:
Originally posted by afrika

first question

Do you have MS SQL installed ?

Yes, 2005.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-01-27 : 14:35:55

Oh i see, sorry am still learning the ropes with 2005.

Much more comfortable with SQL 2k.

Probably someone else would advice on permissions here. But i believe it should be the same
best wishes
Afrika

fatalbert
Starting Member

9 Posts

Posted - 2006-01-27 : 14:45:33

Ok, thanks anyway.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-01-27 : 14:47:50

Glad to help. But read up on permissions in books online

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources