Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Unable To Create SERVERNAME/ASPNET Login


My system config is VISTA Ultimate, Visual Studio 2005 SP1, SQL SEVER 2005 SP2. Using 2005 SQL Server Management Studio I am unable to create a servername/aspnet login account. 
I right click logins and get the new login form; key ASPNET Login Name; select Windows Authentication; click search; I get the Select User or Group form; under object type I select all three; location I select my server name; if I enter SERVERNAME/ASPNET and click Check Names I get an error; if I click Advanced and Find Now; ASPNET is not listed in Name(RDN) list.
I tried aspnet_sql.exe -E -A all; that did not work.
Where can I find information on creating an ASPNET Login after experiencing the above problems?


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Login Failed For 'servername/aspnet'
hi,
I am very new to asp.net..I am creating a webform which connects to sqlserver and  display table contents  to a grid control.When i run this form,i get error message as follows
Login failed for user 'SERVERNAME/ASPNET'.
I have read in one page of this forum that we should create aspnet user in sqlserver..i tried to create user,i can see 2 user Guest and public...I don't know what to do ?
If  someone replies my question,i would appreciate..I have struggling with this for the past 1 week..i couldn't find a solution.
My code  is as follows:
Dim MyConnection As SqlClient.SqlConnection
Dim MyCommand As SqlClient.SqlDataAdapter
Response.Write("hello world")
MyConnection = New SqlClient.SqlConnection("server=Localhost;Integrated Security=SSPI;uid=sa;password=;database=sample")
MyCommand = New SqlClient.SqlDataAdapter("select * from emp", MyConnection)
Dim ds = New DataSet
MyCommand.Fill(ds, "emp")
Response.Write("data set has been created")
DataGrid1.DataSource = ds.Tables("emp").DefaultView
DataGrid1.DataBind()
 thanks
kar

View Replies !   View Related
Log In Failed For User '[servername]ASPNET'
can anyone help me with this error message, i follow the instruction of someone in other forum, but i cant find where the SQL Server Enterprise manager is, i am using MSDE.

View Replies !   View Related
Cannot Open Database Requested In Login 'sql'. Login Fails. Login Failed For User 'ASPNET'.
I am using the MSDE to connect to my ASP.NET application. I get this error after clicking the login button of my login page. Anyone know why this would happen?

Thanks for any help,

Cannot open database requested in login 'DataSQL'. Login fails. Login failed for user 'serverASPNET'.

View Replies !   View Related
Error: Unable To Connect To Server 'servername'
Hi,
 
I am trying to connect to SQL Server through Query Analyzer but getting following error: (SQL Server is at remote web server where i have my website hosted.)
 
Unable to connect to server [server IP]:
 
Server: Msg 6, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][dbnetlib] Specified SQL server not found.
 
I have searched this forum for this error and performed following workaround as suggested in some threads-
 
1. checked and set "TcpPort" registry setting.
2. TCP/IP is enabled in Network Utility.
3. "start SQL server if it is stoped" checkbox is unchecked while connecting.
 
But, I am still getting the above error. Should i re-installed SQL Server 2000? Any help?
 
Thanks,

View Replies !   View Related
Cannot Open Database &"XYZ&" Requested By The Login.The Login Failed For User '[domainname]-[username]ASPNET'.
Hi all,
Iam getting this error
System.Data.SqlClient.SqlException: Cannot open database "XYZ" requested by the login. The login failed.Login failed for user 'xyz-abcASPNET'.
 when trying to open the page.... 
http://localhost:1807/projectname/WebFormName.aspx
as
http://localhost/projectname/WebFormName.aspx
Couldnt figure out the solution.Please help
Soujanya

View Replies !   View Related
Unable To Start T-SQL Debugging. Could Not Connect To Computer 'servername'.
 

I thought I would post how I got remote t-sql debugging working in my environment.  Hope it might help someone.
I have two domains, DomainA and DomainB.  DomainB has a one way external trust to DomainA.   Dev Vista machine running VS 2005 is in DomainA logged in as user DomainAauser.  SQL 2005 running on test Windows Server 2003 DC machine in DomainB under user DomainBuser.   When trying to 'step into stored procedure' in VS, whether my data connection used windows authentication or sql server authentication, I would get the 'Unable to start T-SQL degbuggin...'.  I could debug t-sql when I logged into the domain controller (console or rdp) and running VS on the server.  I changed the SQL Server service to run under the DomainAauser account and I can now remote t-sql debug using both window authentication and sql server authentication.  Hope this may help anyone that might run into this.
 
Regards,
RMcc

View Replies !   View Related
Login Failed For User ASPNET
Hello,I am getting following error when I tried to connect to the database.
Login failed for user 'SHALINIASPNET'
I am new to this and don't know how to fix it. I am running SQL Server Desktop engine 2000. I could connect through Server Explorer window, but not through ADO.NETHere's my connection string:
sConnectionString = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyStore;Data Source=SHALINI;Workstation ID=SHALINI"
I have IIS and SQL Server running on the same machine.Please please help me.Thanks in Advance

View Replies !   View Related
Login Failed For User Machinename/ASPNET
Hi all,   I am new to ASP .NET and now I have been messing two days with the connection thing. I use the Visual Studio 2003 provided drag and drop SqlDataAdapter and SqlConnection to connect to the SQL 2000 server, developer edition (configured with the Windows authentication mode), but whenever I tried I always got a "Login failed for user  mymachine/ASPNET" error. Can anyone help me with this? I have also tried, as somebody did, adding one line "<identity imperonate="true"/> to the Web.config file, but had the same kind of error. Do I have do make some change to my SQL server?   Thanks a lot! Charlize 

View Replies !   View Related
Desperate! Aspnet.mdf Screwed Up; User Login Impossible...
I hope anyone can help me with this. I am having problems connecting to the aspnet database. It
all started when I noticed that I could not log in to my webapplication
anymore under debug mode, although I was able to log in when remotely
accessing the website. I got the error message that the machineaspnet
user did not have access to the database:  "Login failed for user
'GM-FEDORSASPNET' "This was highly peculiar and rather annoying so I tried several things to straighten this out, but it only made things worse!I
read that this had to with permissions of the database in question, al
though I could not understand why permissions suddenly had changed. I
tried to change the rights by attaching it to Management Studio Express
and defining an aspnet login, but that failed because a login under
that name was not accepted. I tried to make a copy of aspnet.mdf, delete the original and rename the copy to aspnet.mdf. When that didn't work, I then deleted the aspnet.mdf, counting on it that it would be regenerated automatically, but alas. I located the aspnet_regsql.exe tool to regenerate the database, but got the following error message: System.Web.HttpException:
Unable to connect to SQL Server database. --->
System.Data.SqlClient.SqlException: An error has occurred while
establishing a connection to the server.  When connecting 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: Named
Pipes Provider, error: 40 - Could not open a connection to SQL Server)What can I do? 

View Replies !   View Related
Login Failed For Localhost/aspnet - Please Help, Been Trying For Week To Solve
I am really at my wits end.  I have been trying for days to find an answer to this, and have tried so many things. 

I simply keep getting the error that localhost (Phantomlap in my case)/ASPNET cannot access the DB. This is a synopsis:.

Tools I am using:

V Studio 2005, IIS 5.1, XP Pro SP 2, SqlServer 2005 (using the EXPRESS server).

Configurations:


web.config:


<connectionStrings>
 <remove name="localsqlserver"/>
 <add name="localsqlserver" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|aspnetdb.mdf;Integrated Security=true;User Instance=True"
   providerName="System.Data.SqlClient" />
</connectionStrings>

Website is stored at:

C:Inetpubwwwroot
(within that I have an App_Data folder with following permission):
(I allowed, via security, the ASPNET account read/write access)

SQL Server status:
Phantomlap/aspnet user is added
Phantomlap/aspnet security as just about everything checkmarked

Please note--I am using SQLServer Express--I am not entirely sure I added the ASPNET account correctly--is there a tutorial on how to do this?

Please help,

Kind Regards

View Replies !   View Related
How To Add Login User (ASPNET) To MS SQL 2000 Desktop Engine Server (MSDE2000)?
How do I add login user ASPNET to my SQL 2000 Desktop Engine Server?. I can not find the "Server Manager" in the Start - Programs. Is there any other way to get around adding ASPNET login to the SQL server so I can test my VB program. I got the error: Login failed for user 'com_nameASPNET'.

View Replies !   View Related
How To Create ASPNET User In SQL Server 2000
Respected Members,
I have a question, when our aspx page is trying to access the SQL Server 2000 database than before this do we have to creaete a user with the name of ASPNET in SQL Server 2000, or without creating this paticular user(its the default user of ASP.NET account) our aspx pages can also access the SQL Server 2000,I have already SQL Server 2000 running in "SQL Server Authentication Mode" so while creating the user do I have to create it in "Windows Authentication" or "SQL Server Authentication", can you provide some link where I could find complete steps for craeting the ASPNET user or if some one can tell all the steps in details here.

View Replies !   View Related
How To Create ASPNET User In SQL Server 2000
Respected Members,

I have a question, when our aspx page is trying to access the SQL Server 2000 database than before this do we have to creaete a user with the name of ASPNET in SQL Server 2000, or without creating this paticular user(its the default user of ASP.NET account) our aspx pages can also access the SQL Server 2000,I have already SQL Server 2000 running in "SQL Server Authentication Mode" so while creating the user do I have to create it in "Windows Authentication" or "SQL Server Authentication", can you provide some link where I could find complete steps for craeting the ASPNET user or if some one can tell all the steps in details here.

View Replies !   View Related
Unable To Complete Login Process Due To Delay In Login Response
I receive this error message occasionally in my ETL - usually when trying to pull data from our source system:

An OLE DB error has occurred. Error code: 0x80004005.  An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Login timeout expired".  An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Unable to complete login process due to delay in login response".  An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "TCP Provider: Timeout error [258]. ". 
There is a setting in the connections manager, under the ALL tab, Initialization, Connect Timeout.  It is set to zero, which would be the default.  It appears (by looking at the timestamps in my error log) that the default is 15 seconds.  If I change this to a higher value (60 seconds or so) should this fix the error?

Thanks,

Evan Black

View Replies !   View Related
How To Create A SQL Server 2005 Database In The App_Data Folder Of An ASPnet 2.0 Web Site?
On my VWD 2005 Express, I have installed 2 SQL Server 2005 Express databases in the App_Data folder.I kind of remember these 2 databases were installed from Wrox web site or a zip file. Now we still useSQL Server 2000 databases for our ASP.net applications.  I have downloaded the SQL Server 2005 Express.These 2 databases in the App_Data folder seem to work fine although I can not see them from theManagement Studio Express. 
My question is: How do I 'manually' create a new SQL Server 2005 database into the App_Data folder?
TIA,Jeffrey

View Replies !   View Related
How To Fix ASPNET &"Login Failed&" Problem With MSDE
I've searched all over the web trying to find a goddamn fix for this problem and no one has it right or they have the commands misspelled (!!!), so in spite of all those idiots, in spite of the makers of the Web Matrix guided tour for not pointing out this problem, and in spite of Microsoft who has not posted a solution themselves, here it goes:

* !! Change MYCOMPUTER below to the appropriate name of your computer !!
* Open a command prompt
* Type: C:
* Type: cd "C:Program FilesMicrosoft SQL Server80ToolsBinn" (or the exact location of the file "osql.exe" if different)
* Copy/paste the following commands

osql -E -S localhost -Q "sp_grantlogin 'MYCOMPUTERASPNET'"
osql -E -S localhost -d Orders -Q "sp_grantdbaccess 'MYCOMPUTERASPNET'"
osql -E -S localhost -d Orders -Q "sp_addrolemember 'db_owner', 'MYCOMPUTERASPNET'"

View Replies !   View Related
&"Login Failed For User 'MyPC/ASPNET'&"
Hi
I created my DB in SQL 2005 Express in VS IDE. I have my app in IIS. When I try to use the DB (e.g. try to login a user in the app) it gives me the following error:
Cannot open database "cvRepository" requested by the login. The login failed.Login failed for user 'MyPCASPNET'.
My guess was that I had to give permissions to ASPNET user so I did in SQL Server Management. Still not working! Checked my Connection string and I think it's fine...
connectionString="Data Source=.SQLEXPRESS;Database=cvRepository;Integrated Security=True;User Instance=True"
Still not working!
Can anyone explain me what's wrong and to solve this?!

View Replies !   View Related
Using Local Variable To Pass Login Name To CREATE LOGIN Script
Dear all;
 
I'm trying to use a local variable @NEW_LOGIN_CODE to pass LOGIN NAME to CREATE LOGIN script as follows:
 
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
declare

@NEW_LOGIN_CODE varchar(255),
@NEW_LOGIN_PASSWORD varchar(255);
begin

SET @NEW_LOGIN_CODE = 'any_login';
SET @NEW_LOGIN_PASSWORD = 'AnyPassword';
 
CREATE LOGIN @NEW_LOGIN_CODE WITH PASSWORD @NEW_LOGIN_PASSWORD;
end
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 
the script will not work unliss I provided a hard coded login code and password as follows:

CREATE LOGIN ANY_LOGIN WITH PASSWORD 'AnyPassword'
 
what should I do to make the CREATE LOGIN script accept local variables as parameters?
 
Thanks
 

 

View Replies !   View Related
Why @@servername Is Not Showing The Servername?
 

Hi
 
I have explicitly used
Exec SP_dropserver  and
Exec SP_Addsserver SP's to drop and add a SQL server.
 
After that i restarted the sql server service. After that, when i used the query

select @@servername, it is returning NULL.
But, when I used Select Serverproprty('servername'), it is returning me the correct servername.
Can i know as why this behavior is exhibited for the same property of finding servername?
 
Thanks!
 

View Replies !   View Related
Cannot Create An Instance Of OLE DB Provider &&"SQLNCLI&&" For Linked Server &&"SERVERNAME&&", Error: 7302
 

I just installed a SQL Server 2005 Express SP2 instance on a server with an existing SQL Server 2000 SP3 installation.  (I need SQL Server 2005's INSERT from an EXEC capability).  It's working great now except for one thing: I can't link any other SQL servers!  I've already successfully added and queried a linked Oracle server, but attempting to add a linked SQL server gives me the following error, no matter which SQL provider I try to use:
 



Code Snippet
"The linked server has been created but failed a connection test.  Do you want to keep the linked server?"
Additional information:
  --> An exception occured while executing a Transact-SQL statement or batch (Microsoft.SqlServer.Express.ConnectionInfo)
    --> Cannot create an instance of OLE DB provider "SQLNCLI" for linked server "SERVERNAME". (Microsoft SQL Server, Error: 7302)
 
 
The technical details reveal the error source as "sp_testlinkedserver".



 
I've scoured the net and premier support for advice on this problem, but the little I found wasn't helpful.  I've tried reinstalling the SQL Native Client, but it didn't help.  I've tried uninstalling SQL Server 2005 Express completely (including management studio and native client), rebooting, and reinstalling everything, with no luck.  The server (obviously) does not have a firewall enabled.  I've tried stopping the SQL 2000 Server installed on the system, no help.  If I create a test .UDL file on the system, pointing to any of the SQL servers I'm trying to link, clicking the "Test Connection" button returns successful.  I'm also able to connect to and query the servers directly from the SQL 2005 Express Management Studio.  I just can't add them as linked servers.
 
The server is running Windows 2003 SP1, SQL Server 2000 SP3, and SQL Server 2005 Express SP2 (the default "SQLExpress" named instance).  I've tried setting up SQL 2005 Express to run under the network service account and under a domain account used by the other SQL 2000 servers.
 
From other SQL 2000 servers, I can connect and link to the SQL Server 2005 Express instance successfully.   I can also successfully add linked SQL servers in SQL Server 2000 instance installed on the same server.  Only adding linked SQL servers in 2005 Express seems to be broken.
 
Anyone have any other suggestions?  I'm totally baffled.  Thank you so much for any helpful advice.

View Replies !   View Related
LINQ Unable To Login To DB
 Hello all, I have Membership Authentication services in my application, connecting to a remote SQL Express DB, using a saved username and password (saved in Web.Config connectionStrings).Everything
works fine with Membership: i created pages to "sign up" and "log
in"... and usernames are stored in the DB with no problems, users are
able to register and login with no problems.
However, i'm trying to use LINQ to access non-asp-services
tables from the same DB, for example, add record to table "comment": I
have addComment() method which uses LINQ's InserComment() and
SubmitChanges().I use to get the error "Login failed for user
tmpOO" when I try to add a comment, then I played with the settings and
now I get nothing - no error, the page is loaded as if everything went
fine, and no record is added to DB. I'm using IIS7 and Visual Studio 2008 Pro. These are my settings (i didn't change anything else..... i think): IIS7->Website->Authentication:    - Anonymous authentication: enabled    - ASP.NET impersonation: enabled    - Forms authentication: enabled Web.Config:    <identity impersonate="true" /> Regards,Naimi

View Replies !   View Related
Unable To Login, Only One User SA
Hi there,

I am novice to SQL, I have a software which uses SQL as backend. The software is made in such a way that during its installation it runs a stored procedure which deletes all users except SA. Now when I try to login to SQL either via Enterprise Manager or via query analyser it asks for password. When I put the password it gives error
"Unable to connect to server. msg:18456, level 16, state 1[microsoft][odbc sql server driver][sql server] login failed for user SA. Someone told me that it is unable to connect to server. But the main thing is that I dont have any client I have only server. What could be the possible reason.
1)Is there anyway of creating a user in SQL in such a situation when there is only one user SA and it is unable to log in SQL server.
2)Or is there anyway of removing SA Password.
3)Or is there anyway (in SQL SERVER) of stopping a particular procedure from getting executed while software installation.

Thanking you and waiting for some kind replies.

Regards,


Mystical

View Replies !   View Related
Unable To Map Users To The Login
I am new to this, so, I will be greatful to anyone who can clarify the following:
 
qn 1: 
In login properties under Logins of Security, what does creating mapping to the different databases mean ?
 
For a given login, I notice that I can login / execute DDL statements alike for the databases which are checked and also for the ones that are not checked.
 
Then, what does
Security -> Logins - > Login Properties -> User mapping -> Users mapped to this login -> checking the database - accomplish?
 
qn 2:
For a perticular login, say 'Bob' which has server admin rights, I wish to include two more databases. For this I 'checked' the databases, which I wish to include, in the

 
Security -> Logins - > Login Properties -> User mapping -> Users mapped to this login
 
When I clicked 'OK', I get the following error and the two databases are left unchecked. 
 
User, group, or role 'SQL1AGENT' already exists in the current database. (.Net SqlClient Data Provider)
 
How can I include the databases ?

View Replies !   View Related
Db_owners Unable To See Login List
Hi. We are using SQL Server 2005 64-bit on Windows Server 2003 R2 x64Enterprise Edition. I have a really weird problem where I have peopleout there who are placed in the db_owner, db_accessadmin, anddb_securityadmin roles in their database, and yet they are unable toadd new users to their databases, despite the fact that logins existfor these users on the server. The reason is that when attempting toadd a new user in Management Studio, upon using the "Browse" option tolook at the logins, the complete list is not presented to them. Infact, they only see a couple of logins or so (the server has hundredsof logins). Also, if they try to type in the login name directly,they get a "permission denied" error message. Since they cannot addusers to their databases, they have to call me and have me do it forthem.I created a test, non-privileged, SQL-authenticated login to testthings for my own sake, and when logged in under the test account, Isaw the same behavior. I had db_owner role for a single testdatabase, and when I went to add users, the only server logins thatwere displayed were my own (the test login in this case) and that ofsa. Further, when I queried the master.sys.syslogins view, I saw thesame thing, it only came back with the rows for myself and sa.It appears that this is clearly a security problem, but I'm not sureat what level to look. We never had this problem with SQL Server 2000or earlier. Does anyone have any idea what I can do to allow mydb_owners to see all the server logins, and therefore be able to addusers to their databases as they see fit? I really do NOT want toassign them to server-level security roles, for obvious reasons.Thanks,SkyGringo

View Replies !   View Related
Unable To Login SQLSrvr 7.0 With 'sa' User
Hi

I am running into a problem loggin into SQLsrver 7.0 using 'sa' account but works fine admin account(NT acct)

I have installed sqlsrvr 7.0 on win2k - server standard edition. Installed SQLserver using NT domain account. I have created a username 'sa' with admin previleges. When I try to login with sa, login fails in the enterprise manager. ?

I tried to re-install the server7.0 using local account, again unable to login with 'sa' account in the enterprise manager

Appreciate if you could shed some lights on this issue

View Replies !   View Related
Unable To Login To Database Created By Admin
Using SQL Server 2005 under XP Professional.  I am attempting to log into the Server Management Studio as "UserX".  I had previously been using Server Management while logged in as admin.
 I now get this error message when attempting to connect to the database server:
 **********************************************************************TITLE: Connect to Server------------------------------Cannot connect to [**NAME OF SERVER**].------------------------------ADDITIONAL INFORMATION:Login failed for user '[**NAME OF SERVER**].UserX. (Microsoft SQL Server, Error: 18456)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476------------------------------BUTTONS:OK------------------------------
*******************************
 Microsoft help doesn't have a specific help for that particular error message.  Any hints as to what is going wrong?

View Replies !   View Related
Unable To Set The Publisher Login For The Updatable Subscription
I keep getting this following error when trying to set-up an updateable subscription on SQL 2005 (latest service packs). Server is set for mixed mode auth.
 At the final stage of the new subscription wizard I get:
Unable to set the Publisher login for the updatable subscription. You may have to set this up directly on the Subscriber machine using sp_link_publication. (New Subscription Wizard)
 The user is not associated with a trusted SQL Server connection
 Login failed for user ''. The user is not associated with a trusted SQL Server connection
 Error Number: 18456, Severity: 14, State: 1,Line Number: 1
 

Can anyone recommend a possible way of debugging this? Is it some issue with RPC security?

 

View Replies !   View Related
SQL Unable To Start After Login Account Change
I have a SQL 2k5 ent. 64 bit on Windows 2003 Ent x64 edition.

 

The sql server was running fine under localsystem account.  Recently I changed the service account to a local user (part of users group in windows) and implemented permissions according to KB article 283811.  (have imlpemented the same on many other sql servers without issue).

 

However, the SQL services are not starting up and I am seeing the following errors in the errorlog.

 

===================

2007-07-25 12:36:55.90 spid11s Server name is 'HBCARPROD'. This is an informational message only. No user action is required.

2007-07-25 12:36:55.90 spid13s Starting up database 'model'.

2007-07-25 12:36:55.90 Server Error: 17182, Severity: 16, State: 1.

2007-07-25 12:36:55.90 Server TDSSNIClient initialization failed with error 0x5, status code 0x51.

2007-07-25 12:36:55.90 Server Error: 17182, Severity: 16, State: 1.

2007-07-25 12:36:55.90 Server TDSSNIClient initialization failed with error 0x5, status code 0x1.

2007-07-25 12:36:55.90 Server Error: 17826, Severity: 18, State: 3.

2007-07-25 12:36:55.90 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2007-07-25 12:36:55.90 Server Error: 17120, Severity: 16, State: 1.

2007-07-25 12:36:55.90 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

 

====================================

 

I have gone through the http://blogs.msdn.com/sql_protocols but everything mentioned here seems to be there.  I understand this is some permission issue.  Just not able to find it out.  Can anybody help?

View Replies !   View Related
Error 17832: Unable To Read Login Packet
Client of mine has a major problem with the Error 17832 (accompanied by 1608) on MS SQL
Server 6.5 running on NT 4.0 SP3. SQL Server has 100 per-seat licenses.

Application, running on the client computers, establishes several connections (I know...) to
the SQL Server on as-needed basis. The errors started to come up when application has
executed on 40+ workstations. When the "saturation level" is reached, no connection to the
SQL server could be established (even for Enterprise Manager, running on the same NT box!)

Any suggestions? Licenses, network, client configuration, SQL Server configuration...
Your suggestions sent to vadim@prosysllc.com will be appreciated.

Thanks,

Vadim Brusilovsky

View Replies !   View Related
Unable To Read Login Packet(s) Error Messages
We have been getting the following error message on SQL Server 6.5 SP 5A every 2 minutes:

Error : 17832, Severity: 18, State: 0
Unable to read login packet(s).

Even though it does not cause any problems, it really fills up the Error Log, which makes the log take a lot of disk space. From researching this problem, I realize that it has something to do with the network. Could anybody suggest what is it specifically on the network that could be not set up properly?

Thank you for your help.

Marina Somers

View Replies !   View Related
Unable To Drop Login Due To Existing Event Notification
Hi
 
I am unable to drop the above login. The error is Error:15141 The server principal owns an event notification and cannot be dropped.
 
I have looked in the table sys.server_event_notifications and there are rows returned that have a server_principal_id of the user I am trying to drop. No events have been created on this server, so I am assuming these notifications are either created by default or are somehow related to Database Mail?
 
All the event notifications belong to service name "SQL/Notifications/ProcessWMIEventProviderNotification/v1.0" and begin with SQLWEP (i.e. SQLWEP_RECHECK_SUBSCRIPTIONS, SQLWEP_B415ADB8_A604_4057_976F_600002FA5AF6). How can I find out what these are for and how they were created?
 
What purpose do these event notifications have? Is there some syntax to change the owner of these event notifications so I can successfully drop the login? If the only way is to directly update the system view, is this safe and what repercussions could this have?
 
Thanks
Martin
 

View Replies !   View Related
Unable To Login To Reporting Services On Local Host
 I am trying to setup Reporting Services on my local machine. I have installed SQL 2005 Developer Edition on my laptop and when I goto http://localhost/reports/Pages/Folder.aspx I receive the following error:





The report server is not responding. Verify that the report server is running and can be accessed from this computer.


I checked in the Event Viewer and I see some cryptic error by SQLDUMPER:

EventType sql90exception, P1 aspnet_wp.exe, P2 2.0.50727.1433, P3 471ebf4c, P4 sqldumper_unknown_module.dll, P5 0.0.0.0, P6 00000000, P7 0, P8 0f11432d, P9 00000000, P10 NIL.
 
I have the reporting server sevice running under my domain account. I also went into Reporting Services Configuration and all checks are green. 
 
Does anyone have any additional suggestions on what might be causing me to not be able to access this locally?

Thanks,
Flea#

View Replies !   View Related
Unable To Create Database
Hi, I need urgent help with this problem because I am unable to do any database development due to it. I am using visual web developer express edition with sql server 2005 express edition. The problem is that when I try to create a database in the app_data folder I get the following error message: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed".
Regards, sandy

View Replies !   View Related
Unable To Re Create Index
Hi

I was asked to import some data from excel into a table within a sqlserver 2000 db the import was complaining about an index so then I deleted the index imported the data succesfilly but I'm now unable to re create the index, please see the error that I'm getting below. Can someone please help.
Thanks

- Unable to create index 'trainingGo'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 32. Most significant primary key is '439'.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

View Replies !   View Related
Unable To Create Function
Hi All,

I'm running SQL Server 2002 and trying to create a User Defined Function. However, everytime I try to save the script I get Error 170 Incorrect Syntax near 'FUNCTION'.

This happens if I create the Function from Code or use the Enterprise Manager. I'm logged in with 'sa' privs, so I don't think it's a privilege issue. I'm well confused.

Anyone help?

TIA

William.

View Replies !   View Related
Unable To Create Diagrams
Hi,
My dba has setup permission such that I can do everything except I am unable to create diagrams in the database. It say I don't have enough permission to do that. Can somebody tell why I am unable to do that?
thanks
Rozina

View Replies !   View Related
Unable To Create Relationship FK
Hi.
I get this error when i try to create a relationship in a db diagram (sql 2005)
"'tblActivedir' table saved successfully
'tblClient' table
- Unable to create relationship 'FK_tblClient_tblActivedir1'.
Introducing FOREIGN KEY constraint 'FK_tblClient_tblActivedir1' on table 'tblClient' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Could not create constraint. See previous errors."


What i have is 2 tables.
1 named client
1 named activedir

In the client table the columns i want to bind with activedirtable are FR1 and DC1
I want to bind them in the ID of the activedir table (both, in different fk relationships) so that they get the id of activedir.
Fr1 has an fk relationship with activedir (pk is activedir' id)
and DC1 exactly the same in another fk.
So i want both columns to comunicate with activedir.
If p.e. activedir has 3 elements (a,b,c) when i delete element a then werever FR1 or DC1 have this element(binded to it's id) then the element will also be deleted (id of the element) from both FR1 and DC1
I don't want to set Delete and Update action to none because i want the element changed or deleted from activedir, to do the same on Fr1 or DC1 or both.
Any help?
Thanks.

View Replies !   View Related
Unable To Create New Database
I had a fully functioning SQL 2005 Exp install until today. All of my DBs work, Reporting Services works. But today I went to add a new DB for a DotNetNuke installation. Everything I have tried fails with the same error:

*****************************************************
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Create failed for Database 'TEST'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
A file activation error occurred. The physical file name 'G:TEST.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 5105)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5105&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
*****************************************************

I have looked high and low for a solution only to come up empty handed. I only hope at this moment that someone here has seen this before.

Thanks

Jason

View Replies !   View Related
Unable To Create Subscriber
Dear Friends,

I have two different sql servers one two different domains connected by internet. Iam working on Doman-A. Both sql server's are 2005

Domain Name  System Name         Sql Instance Name             Port No

Domain-A       SysA(IP:202.187.65.124)     SqlA                              1215

Domain-B       SysB(IP:102.45.68.125)       SqlB                               1465

Intially I was unable to connect from SysA to SysB through sql management studio. But after giving the connection string as 102.45.68.125SqlB,1465 I was able to connect. Now my main problem is with the replication only. I had configured Publisher and Distrbutor on SysA. I want the subscriber to be SysB. But when I try to configure the subscription in the New Subscription Wizard from SSMS installed on SysA and try to Configure the subscription I get the following error message:

TITLE: New Subscription Wizard
------------------------------

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'SysBSqlB'. (Replication.Utilities)

Plz help me guys.

Thanking you

Chandra Mohan N

View Replies !   View Related
Unable To Create A Database In VB
I've recently installed VB Express and SQL Server Express (including
Management Studio Express) on a laptop as well as a desktop PC.
Everything looks the same on both. I can create an SQL database
from VB without any problems on my laptop. However, when I try to
create a new SQL database from VB on my desktop, I get the following
message:

"Failed to generate a user instance of SQL Server due to a failure in
starting the process for the user instance. The connection will be
closed."



I've written a number of databases in Access, but never used SQL Server. This is about to drive my crazy.



Thanks.

View Replies !   View Related
Unable To Create New Web Site In IIS 5.1
Hi,

I need to create a new web site in Internet Information Service.

This can be done by opening IIS manager.

In IIS Manager, expand the local computer, right-click the Web Sites folder, point to New, and then click Web Site. The Web Site Creation Wizard appears.

But if i right click the Web Site Folder. only Properties and Refresh option is showing.New option is not shown.

I will appreciate if any one give solution to solve this problem.

I am using Windows XP with SP2.

 

Thank you

 

View Replies !   View Related
Unable To Complete Login Process Due To Delay In Opening Server Connection
I am getting an error in Replication between SQL Server 2005 and SQL Express when "Connecting to Subscriber". Detailed error message is given below. Do we need to increase the logintimeout for "Connecting to Subscriber". How can we increase it?

Message
2007-10-15 06:37:58.398 Startup Delay: 8503 (msecs)
2007-10-15 06:38:06.898 Connecting to Distributor 'ACR-MANGO'
2007-10-15 06:38:06.976 Initializing
2007-10-15 06:38:06.976 Parameter values obtained from agent profile:
-bcpbatchsize 2147473647
-commitbatchsize 100
-commitbatchthreshold 1000
-historyverboselevel 1
-keepalivemessageinterval 300
-logintimeout 15
-maxbcpthreads 1
-maxdeliveredtransactions 0
-pollinginterval 5000
-querytimeout 1800
-skiperrors
-transactionsperhistory 100
2007-10-15 06:38:06.991 Connecting to Subscriber 'ACR-ANJILISQLEXPRESS'
2007-10-15 06:38:46.133 Agent message code 20084. The process could not connect to Subscriber 'ACR-ANJILISQLEXPRESS'.
2007-10-15 06:38:46.148 Category:NULL
Source: Microsoft SQL Native Client
Number: 08001
Message: Unable to complete login process due to delay in opening server connection
2007-10-15 06:38:46.148 The agent failed with a 'Retry' status. Try to run the agent at a later time.

View Replies !   View Related
Unable To Get To Create Stored Procedures.
Hi,I was following this tutorial: http://asp.net/learn/data-access/tutorial-67-cs.aspxI got to the point where this picture is displayed: http://static.asp.net/asp.net/images/dataaccess4/67fig05CS.pngHowever, for some reason only "Use SQL statements" was enabled as a component, all of the other ones were grayed out and I couldn't continue with the tutorial. I've created ObjectDataSources before and then DataSets and then bound the two together later on, but at the time I didn't bother with custom functions.Does anyone know any possible reason whatsoever that could have grayed out those two other options?

View Replies !   View Related
Unable To Attach Or Create Database
Hello,
I just recently installed SQL Express 2005 on a new OS which is on Vista Ultimate.
When I try to attach a database by clicking the add button, I receive this error:
===================================
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------Program Location:
   at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)   at Microsoft.SqlServer.Management.SqlManagerUI.BrowseFolderHelper.GetBrowseStartPath(ISettingsStorage settingsStorage, ServerConnection serverConnection, Type controlType, String settingKey)   at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.GetStartPath(String settingName)   at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.buttonBrowse_Click(Object sender, EventArgs e)   at System.Windows.Forms.Control.OnClick(EventArgs e)   at System.Windows.Forms.Button.OnClick(EventArgs e)   at System.Windows.Forms.Button.WndProc(Message& m)   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
===================================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------Program Location:
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)   at Microsoft.SqlServer.Management.Smo.ExecuteSql.ExecuteImmediate(String query)   at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult erParent)   at Microsoft.SqlServer.Management.Smo.Environment.GetData()   at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)   at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)   at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
===================================
The server principal "MyComputerKarl" is not able to access the database "model" under the current security context. (.Net SqlClient Data Provider)
------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476
------------------------------Server Name: MyComputerSQLEXPRESSError Number: 916Severity: 14State: 1Line Number: 1
------------------------------Program Location:
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
 
When I try to creat a new database I receive this error: 
===================================
Create failed for Database 'TestDB'.  (Microsoft.SqlServer.Express.Smo)
------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
------------------------------Program Location:
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()   at Microsoft.SqlServer.Management.Smo.Database.Create()   at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.ApplyChanges(Control marshallingControl)   at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabase.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult)   at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType runType)   at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForSql(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)   at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)   at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender)
===================================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------Program Location:
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext)   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery, ScriptingOptions so)   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
===================================
CREATE DATABASE permission denied in database 'master'. (.Net SqlClient Data Provider)
------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476
------------------------------Server Name: MyComputerSQLEXPRESSError Number: 262Severity: 14State: 1Line Number: 1
------------------------------Program Location:
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
On my previous computer which had WinXp Pro I had no such problems
 Any Help would be much appreciated
Thanks
Karl
 
 
 

View Replies !   View Related
Unable To Create A Step In A SQLServer Job
I am running SQLServer 2000 SP3 with MDAC 2.8.On instances created via MSDE, I am unable to create the first step ina job. Instances created with SQLServer 2000, this problem does notoccur.The message I am receiving on the instances created with MSDE, themessage I get immediately upon pressing the Add button to define a stepis "Error 170: Line 1: Incorrect syntax near ''"Any help would would be greatly appreciated.Wardell Castles

View Replies !   View Related
Unable To Create A Maintenance Plan
Hi,I get the following error while trying to create a maintenance planthrough the UI of Mangement Studio - SQL 2005 standard edition. We dohave SSIS installed.---An OLE DB error 0x80004005 (Client unable to establish connection)occurred while enumerating packages. A SQL statement was issued andfailed.Any help would be greatly appreciated.ThanksKR

View Replies !   View Related
Unable To Create Stored Procedure
I tried to create a stored procedure but instead of opening up to a new stored procedure it displays an exist stored procedure. I erased the code and typed in my code now i received this error message.

MS SQL-DMO (ODBC SQLState:42000)
Error 2729: Procedure ‘spUpdate_date_time’ group number 1 already exists
in the database. Choose another procedure name


Does anyone know how I can fix this?

Your help is appreciated

View Replies !   View Related
Unable To Create Index 'PK_Table'
HI ,

I accidently removed the primary keys in my table , Have ben trying to "reset " the primary keys since then but to no avail.....is there a way that i can "recreate" those primary keys so that it can be the same as before ....I kep getting the error


Unable to create index 'PK_Table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is '1'.

Pls Help

Thanx
Burner

View Replies !   View Related
Error 262 Unable To Create Database...
Hi

I am a complete newbie here. I have spent hours trying to create a database - (even installed on XP and Vista) and I seem to not be able to create a database - it tells me that:

Create Database permission denied in database master - Microsoft SQL Server Error 262.

How to I enable these priviledges?

Do i need to regsiter the Server with the Enterprise Manager and how do I do that?

All help VERY gratefully received thanks Lister

View Replies !   View Related
Unable To Create New Maintenance Plan
I am unable to create new maintenance plan in my SQL Server 2005 Enterprise Edition SP2. I am getting the following error. Please some one help me.
 

TITLE: Microsoft SQL Server Management Studio
------------------------------

Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI)

View Replies !   View Related
Unable To Modify Or Create New Tables...
Getting this message on my event log:

 

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved