I don't know how! The web server said made an server error.  So... I tried to post again. I didn't know it was posting anyway. It just gave me an...

These ascii codes might be a more complete list.

The password characters are not allowed for or the canonical ENCRYPT =

function does not work with characters with the following ASCII codes:

(33,40,41,42,59,63,64,91,93,123,125,130,132,133,134,135,136,137,139,161,

162,166,167,168,169,171,172,173,174,175,176,177,180,182,184,187,188,189,

190,191,215,247)

The period is not listed on the link but once i take it out of my password, THERE ARE NO ERRORS! 

Here is a...

I figured it out!

I found the answer here http://www.eggheadcafe.com/forumarchives/SQLServersecurity/Jun2005/post23406753.asp

it appears that certain characters (such as periods on other characters) don't work...

Thanks very much man for the info!

"You should note, however, that you can't appy an AppRole more than once to any given connection - you will get an error. "

If i...

thanks it does help except i'm having problems encrypting my password. 

I get the following error:

[Microsoft] [ODBC SQL Server Driver] Syntax error or access violation

My book doesn't have sp_helprole.

It says: "

sp_helpuser [[@name_in_db =] 'username']

Here, username is optional and is either a username or role name.

If you don't specify a username, a report of all...

Thanks a million!  The connect string worked without any problems (using my login at least). Now i have to see if it will use my application role that i set...

Thanks for the site. I'm going to give it a try.

Thanks man! I thought it had worked but it didn't.  My server still says LOCAL it does not have my server name in Enterprise Manager. 

When i click the drop...

I created an application role on the database.

Using the Data Link Properties dialog I chose the provider.  Then on the Connection tab, I had to type in the Server name because...

Thanks for the info!

I am using Windows Authentication Mode and this query does show the list of users.

And i guess deleting a Windows login does not delete his permissions on SQL server because...

Thanks!

I figured it out THANKS!  There is a tab below that has a column listing the attributes of the Field.  One says IDENTITY. After setting the PK it still says...