Poking A Hole In Vista Firewall For Sqlserver Login
Jan 5, 2007I've tried letting in 1433,1434 443,444 and I still can't get through. When I turn off the firewall, it works. What Am I missing?
View 3 Replies
ADVERTISEMENT
Bizarre Issue With Vista Firewall And Domains...
Feb 5, 2008
Good afternoon,
3 of my fellow employees and I am having some strange issues with SQL Server...
When we are connected to the local network, we are unable to log into our SQL Server Instances locally through SSMS or programs that use SQL Server unless we have our firewalls "default"(no exceptions). Of course, this is useless if we need to make client connections from other computers. So, if we add an exception, say "port 1433", the client CAN connect, but we can no longer connect locally...to ANY instances.
We have tried adding exceptions to the firewall for all SQL ports and programs. We've also made sure we've got the latest hotfixes and service packs. If I log in as the local computer admin and do not connect to the domain and turn off my firewall, everything works fine.
1. Tried enabling Remote Connections
2. Allowed multiple ports through firewall
3. Allowed multiple programs through firewall
4. Re-installed SQL
It's almost as if something on the local network or domain is causing an issue with our firewall.....
Anyone have any ideas?
Thanks,
Output Parameter Poking My Eye Out
Nov 3, 2005I'm having a blast.I've been trying to get a sproc to work with 3 imputs and 1 output parameter, first I thought it was something wrong with my asp.net (v2.0) code but after some high pursuit code searching I finally tried out the sproc in QA, still didn't work. can you see what's wrong with this sproc?CREATE PROCEDURE gogogod.sp_user_add@username varchar(24),@password varchar(64),@email varchar(64),@errCode varchar(128) OUTPUTAS IF NOT EXISTS(SELECT username, email FROM tblUser WHERE username = @username OR email = @email ) BEGIN DECLARE @uid uniqueidentifier SET @uid = newID() INSERT INTO tblUser (uid, username, password, email) VALUES (@uid, @username, @password, @email) SELECT @uid AS uID SET @errCode = 'user created' END ELSE SET @errcode = 'User already exists' RETURNfor some reason the sproc asks for a 4th input parameter, I tried just adding " , '' " as a fourth and it 'worked' (i think) I couldn't check if there was an output for the @errcode.any ideas?
View 7 Replies View RelatedSqlServer 2005 Wont Work On Vista
Apr 4, 2007hi,i have installed sqlserver 2005 on windows vista but it couldn't establish a connection with my computer. whats wrong with it? and i write my comp name to the server field which is located on the start window in mssql,
Please help me.Thanks..
Login Problem With Vista
Mar 24, 2007Hello,
I am running for the first time SQLServer Express connections on VISTA and I get the following error:
"Login failed for user 'myuser'. The user is not associated with a trusted SQL Server connection."
Any idea what I am doing wring? (TCP/IP is enabled and the user is sysadmin)
Thanks a lot for any help!
Regards,
Fabian
my favorit hoster is ASPnix : www.aspnix.com !
Cannot Install Sqlserver 2005 Developer Edition With Vista Ultimate
Jul 31, 2007
Currently I am just trying to completely remove all Vista Ultimate's knowledge of installed instances of SQLServer 2005 Developer edition.
I cannot do this for some reason. This all began when I tried to install SQLServer 2005 and it installed but I could not connect to it. Now I have two installed instances that I cannot access, after removing all SQL programs from the Programs and Features icon in the control panel.
I tried running "WIndows Installer CleanUp Utility" as I read in a thread on this forum. This did not help. After going thru and removing all SQLServer programs using the "programs and features" icon in control panel... The installation process shows two installed instances of SQLServer 2005.
1) How can I completely erase all Vista Ultimate's knowledge of any SQLServer 2005 install and start over?
I have downloaded SQLServer 2005 SP 2, and run it, but clearly what I should do, and what Microsoft has asked me to do are not working...
2) What should I be doing to install SQLServer 2005 Developer Edition successfully?
I have been a strong supporter of Microsoft, but this is getting me very frustrated.
Please help,
- Chaz
MSSMSE VISTA Login Problem
Apr 2, 2008Hi,
probably this was answered before but I am not sure what to search for.
I have the problem that I can not log into MSSMSE with one user which had no admin rights. Therefore I changed so now the user has admin rights. Still there is a login error, I can not log in with this user. Only the admin with whom I installed MSSMSE can access it using the windows authentification.
What do I have to change, and where to get access using this other user?
Thanks a lot for any help.
Tim
Login Failed For Sqlcmd Using Integrated On Vista Beta 2
Jun 21, 2006When logged in as a member of the admin group on my box, I cannot connect to my localhost server (SS2005 SP1) using sqlcmd.
sqlcmd -s localhost
Server logs say:
Error: 18456, Severity: 14, State: 11.
Login failed for user 'NORTHAMERICAdavigust'. [CLIENT: <local machine>]
I can connect via Management Studio, which triggers the User Access Control stuff.
How do I get sqlcmd to connect when running as a Standard User?
Dave
Microsoft SQL Server 2005 Cannot Install On Vista, Problem With 'sa' Login
Feb 3, 2008Hi
I have just installed Vista on my computer and now has problems with installing: Microsoft sql server 2005. In the last part during the installation the following error occurs:
"SQL Server Setup could not connect to database service for server configuration..... Login failed for user 'sa'....,"
What is wrong? Why cant I install? Thank you for your help.
Here are more details from log:
SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connections
Service MSSQL$SQLEXPRESS started at Sun Feb 03 09:01:52 2008
SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.
Error Code: 0x80074818 (18456)
Windows Error Text: Source File Name: libodbc_connection.cpp
Compiler Timestamp: Wed Jun 14 16:28:15 2006
Function Name: OdbcConnection::connect@connect
Source Line Number: 148
---- Context -----------------------------------------------
Connecting to SQL Server
ExecuteSqlCommands
Originial error was 80074818 (18456)
ipt
SqlScriptHlpr
Error Code: 18456
MSI (s) (04!E8) [09:02:52:245]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Sun Feb 03 09:02:52 2008
Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qDanish_Norwegian_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Sun Feb 03 09:02:52 2008
Attempt to start service when it is already running
SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connections
Service MSSQL$SQLEXPRESS started at Sun Feb 03 09:02:52 2008
SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.
Error Code: 0x80074818 (18456)
Windows Error Text: Source File Name: libodbc_connection.cpp
Compiler Timestamp: Wed Jun 14 16:28:15 2006
Function Name: OdbcConnection::connect@connect
Source Line Number: 148
Sqlserver Login And User
Mar 30, 2006What is the diffrence between Sql Server Login and Sql server DatabaseUser?I want to put a funtionality in my application from where administartormake Application User.these application user will be made also in sqlserver..Now I am confuse here In sqlserver Login and UserWell I will make both for A new user of my application Sqlserver Loginand Sql server user,Plz help me What to do with It..
View 2 Replies View RelatedHow To Fine A Hole In A Records?
Jul 23, 2005Hi all!I need your help to realize algorithm for stored proc or trigger.tool: MS SQL server 2000, T-SQLTABLE:[unique_id] [mynumber] [week][unique_id] - bigint,primary key, identity auto-increnment[week] - int, 1-53, week number[mynumber] - int, 1 - 7, for every week, daily record one per day, upto 7 per weekso, for every week we have a mynumber from 1 to 7or nothing (if no records for that day),we can insert or delete mynubers in any order, at willEXAMPLE:week 1, mynumber 1,2,3 - so if we insert a new record, mynumber value= 4week 2, mynumber 1,2,3,5,7 - so next mynumber = 4QUESTION:How to use _only_ T-SQL find a missed numbers for particular week whenI'm insert a records?Thanks.Chapai
View 14 Replies View RelatedWhy SQLserver Uses NTlogin Though Select To Use The Sql Login??
Oct 2, 2001I have sql server 2000 loaded on my nt machine. Also have another sql2000 server on the network. I have connected to the these servers thru sql enterprise managers.
We have a vb application which uses sql database. I have created a DSN to the server on the network with the options to use sql login and supplied the username and passwords.
when I try to start the vb application it asks for the which dsn to use. then it gives the sql error message saying login failed for the nt user ( i.e my nt login name) then displays another login box with use trusted connection option checked. I wasn't ables to figure out why the DSN is using the nt login instead of sql login.
Any help is greatly apppreciated. Thank you.
How To Solve The Hole Of Identity Column?
Aug 8, 2004Hi All
I use identity column in a Database.
when I delete some data, it cause the "hole" of identity column.
for example
1 John
2 Mary
3 Sam
4 William
when I delete Mary, the data in table are
1 John
3 Sam
4 William
so the hole of identity column is "2"
I don't want there is any hole of identity column..
I hope the result is
1 John
2 Sam
3 William
IS there any solution for this problem?
SQL 2012 :: Closing A Security Hole
Jul 9, 2015I have a purchased product that has a DB with several thousand tables in dbo. I can't change anything with the default dbo schema other than security. I have a table called dbo.ACCOUNT. It has information from multiple sites on it. I have a reporting team that need only access the information for SITE 1 on the ACCOUNT table and anything in the other 1000+ tables in the dbo schema.
I created a role (Analytics) and granted select access to dbo. I created a schema (Analytics) and assigned it the role. I created a view in the new schema called Analytics.ACCOUNT with a WHERE SITE = 1 clause on it. If they use the view, they see only the things they should. My problem is they can still do a select * from dbo.ACCOUNT and see everything they shouldn't see. How can I close that hole? I am not seeing a solution. If there is no way to fix this with roles/schemas/views, what else can I do?
Some of my pain points. I have this issue with about 30 tables. Creating custom table(s) to isolate data for each site will cost me another 2T of storage. Loading those custom tables every day would be cumbersome. Keeping the DDL in sync with the source table would be cumbersome. With the way I have it set up now, if I deny access to the source tables the view breaks because it needs access to the source tables to dynamically build the view. Here is the code I ran to create everything.
USE[DB]
--create test user login
CREATE LOGIN [Analytics_ETL] WITH PASSWORD=N'XXXXXXXXXXX'
GO
--create user in test database
CREATE USER [Analytics_ETL] FOR LOGIN [Analytics_ETL] WITH DEFAULT_SCHEMA=[Analytics]
[code]....
Security Hole In Stored Procedure
Jul 20, 2005here's my stored procedure:CREATE PROCEDURE proc@id varchar(50),@pswd varchar(20),@no_go int OUTPUTASSET NOCOUNT ONSELECT user_id FROM profileWHERE user_id=@id AND pswd=@pswdIF @@ROWCOUNT = 0BEGINSET @no_go = 1ENDELSEBEGINSELECT date,date_mod FROM ansWHERE user_id=@idSET @no_go = 0ENDUsing the PERL odbc_more_results function I can retrieve the data inthe second select statement whether the rowcount is 0 or not. Anysuggestions how to stop this
View 3 Replies View RelatedBest Data Type To Hole Phonenumber
Sep 19, 2006Whats the best type to hold a phone number in this format with a column in my sql table...should i use varchar???? or something else....any help would be great!!
View 4 Replies View RelatedHow To Grant Backup And Restore ONLY To A Sqlserver Login
Apr 15, 2008Hi guys! When it comes to writing sql statements, I do ok. But I just know the basics on sql server dba stuff.I need to create a sql server login account that has the ability to backup and restore databases, BUT NOTHING ELSE.No ability to change anything other than via the restore process. I figured out how to do the backup portion of my requirement, but not the restore part.Any ideas? Thanks in advance!
View 3 Replies View RelatedMSDE SQLSERVER 2000: Login Failed
Feb 12, 2008Hello
I have a installation of MSDE MSQLSERVER on my machine, in this server i run a local database. The problem began when I uninstalled the msde sqlserver and reinstalled it. The program tha uses the database not are connecting, they prompt: "login failed"
Can you help me?
Vista Remote Connection Problem - Login Failed For User 'xxxxxxx. (.Net SqlClient Data Provider)
May 26, 2007trying to connect to sql server 2005 over the internet. (its a third paty hosting company i'm using)
so i have to connect via tcp/ip using sql server authentication.
my laptop is running vista.
the version of sql server 2005 on my laptopis developer edition with service pack 2.
it worked fine from windows xp and the connection details are valid as it runa fine from .net on the hosting website.
i have added sql serer managemnt studio to the exceptions list in the firewall.
ihave made sure tcpip is enabled in the sql server connection management console.
i have also enabled it in the cliconfg tool
firewall on/off seems to make no difference.
its almost enough to make you turn to oracle and thats saying something considering how long i've been in the microsoft camp...
the error returned is:
Login failed for user 'SQL2005_152092_garethbowen'. (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
------------------------------
Server Name: 'xxxx',1433
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536
Property Login Was Not Set. (Microsoft.SqlServer.Express.ConnectionInfo)
Feb 3, 2008Hi, having a bit of a problem - I'm trying to attach a database in MS SQL Server Management Studio Express. When I try in Windows Authentication I can't see any of my databases when I try to browse, so I had a look around on Google a saw mentioned that I should maybe use SQL Server Authentication. Only I don't know my user name and password, where can I configure this? I remember when I was setting up entering a password, but not a user name. Any ideas? thanksmander
View 2 Replies View RelatedNeed A SqlServer Stored Procedur To Check Login Credentials
Mar 10, 2006Sid writes "Hi,
can anybody plz provide me the stored procedure for checking the credentials(uid,Pwd) of a login page in sqlserver.
Thanks,
Sid."
How To Use Sqlcmd Command To Login To Sqlserver With Sa Account Which Have Empty Password
Oct 11, 2007the password of sa account is empt
I use "sqlcmd -S servername -U sa " command but failed
any suggestions?
thanks
Create Failed For Login 'NT AUTHORITYNetwork Service' (Microsoft.Sqlserver.Smo)
Mar 6, 2008I'm installing Windows Small Business Server 2003 R2 Premium. I am at the stage where I am installing the Premium Technologies. Specifically, I am trying to configure permissions for the new SHAREPOINT instance of SQL Server 2005. When I try to create the new login NT AuthorityNetwork Service, typing it exactly as specified in the instructions, I get the following error:
Create failed for Login 'NT AUTHORITYNetwork Service' (Microsoft.Sqlserver.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Windows NT user or group 'NT AUTHORITYNetwork Service' not found. Check the name again. (Microsoft SQL Server, Error: 15401)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15401&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
The following links yielded nothing:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15401&LinkId=20476
Does anyone know what's causing this? I've done a few installs of SBS R2 Premium and this is the first time I encountered this.
I Can't Login To Sqlserver With A Username And A Password But Works With NT Integrated Security !!
Nov 21, 2006hi
i have created a username and a password in sqlserver 2000 from logins in Enterprise manager
and i permit him to the database i need to connect to ..
and i check all server roles for that user and i make sqlserver authentication for him with a password and then i goto the udl file to connect to that database using that user it fails !! and says
"login failed for that user 'myusername' reason not associated with a trusted sqlserver connection"
while i use NT integrated security it works well
so how can i connect to sqlserver using a username and a password
thanks in advance
Update SubQuery(two Tables), Pls Advice Wats Wrong With The Query. 1 Hole Day I Spent Still Cant Figure
Oct 27, 2006Table A, Table B. need to update table A balance field from table b sum of amount
UPDATE CUSTOMERS SET BALANCE=(SELECT SUM(AMOUNT) FROM PAYMENT,CUSTOMERS
WHERE CUSTOMERS.ID=PAYMENT.ID GROUP BY PAYMENT.ID)
Msg 512, Level 16, State 1, Line 25
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
SQL Server 2005 Setup Of 2 Vista Machines, Can't Get Individual Network Login Accounts To Work On Each Others SQL Server
Apr 16, 2008
Hello all,
I have 2 networked PC's both running vista ultimate
1st is Laptop and is running its own SQL Server at laptoplaptopSQL
2nd is Desktop and is running its own SQL Server at desktopdesktopSQL
Now both machines have seperate windows login accounts.
When I go SQL Server management studio I go to browse and each machine can see the other machines SQL Server, but when I go to login I get SQL Login falied for users" The user is not associaed with a trusted SQL server connection".
So I then go to logins new login and try to add my other pc's user account.
The problem I see is that when I go to search and then location it only shows its own PC's location and not the location of my other networked pc? So if I am on Desktop and in my theory want to add laptopuser to the desktop SQL Server logins I get:
"create failed for login laptopuser
An exception occurred while executing Transact SQL statement laptopuser is not a valid windows NT name. give the complete name
Not sure on where to go from here.
Any help would be great
[298] SQLServer Error: 18452, Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.
Mar 11, 2008I received the above error yesterday and haven't been able to trace it to any job or process running. We haven't implemented any changes to the server in the past few months, and it doesn't look to be a user-established connection, since the Client IP Address of the SSPI handshake error is from the server itself.
I logged this set of messages in SQL AgentServer error log:
Date 10.03.2008 6:15:19 PM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[298] SQLServer Error: 18452, Login failed for user ''. The user is not associated with a trusted SQL Server connection. [SQLSTATE 28000]
Date 10.03.2008 6:15:19 PM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[382] Logon to server '<server>' failed (ConnAttemptCachableOp)
Date 10.03.2008 6:15:19 PM
Log SQL Server (Current - 11.03.2008 2:32:00 PM)
Source Logon
Message
Error: 17806, Severity: 20, State: 2.
Date 10.03.2008 6:15:19 PM
Log SQL Server (Current - 11.03.2008 2:32:00 PM)
Source Logon
Message
SSPI handshake failed with error code 0x80090304 while establishing a connection with integrated security; the connection has been closed. [CLIENT: <IP Address>]
Date 10.03.2008 6:15:19 PM
Log SQL Server (Current - 11.03.2008 2:32:00 PM)
Source Logon
Message
Error: 18452, Severity: 14, State: 1.
Any help in explaining this would be greatly appreciated.
Error: Cannot Open Database Requested In Login 'projectAllocations'. Login Fails. Login Failed For User 'sa'.
Oct 27, 2004Hi,
Im getting this error when attempting to retrieve data from an sql database.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database requested in login 'projectAllocations'. Login fails. Login failed for user 'sa'.
Source Error:
Line 13: objConn = New SqlConnection( "Server=LAB303-066NETSDK; Database=projectAllocations; User ID=sa;Password=mypassword")
Line 14: objCmd = New SqlCommand("SELECT * FROM project_descriptions", objConn)
Line 15: objConn.Open()
Line 16: objRdr = objCmd.ExecuteReader()
Line 17: While objRdr.Read()
Source File: C:finalyearproject2sample.aspx Line: 15
Please Help!! Im a beginner to this, so if anyone knows the answer, take baby steps when explaining. Thanks
Cannot Open Database Requested In Login 'dbName'. Login Fails. Login Failed For User 'machineNameASPNET'
Jul 27, 2005Been looking through the forums for a solution to this problem.I already tried granting access through statements such as:exec sp_grantloginaccess N1'machineNameASPNET'But they don't seem to work.. i vaguely remember seeing somewhere a DOS command line statement that grants access to the ASPNET_WP and that fixed my problem before on another computer.. but this is a new computer and i forgot to write down the command.Can anyone help explain and propose a solution to my problem. Many thanxs.
View 9 Replies View RelatedCannot Open Database Requested In Login 'sql'. Login Fails. Login Failed For User 'ASPNET'.
Dec 19, 2003I 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'.
Firewall Again
May 30, 2001Hi guys.
We have an external webserver/sqlbox not on domain network and internal on domain.
I need to register both servers or need to do a linked server between two.
There is something i found in Multi protocol. Will somebody explain the whole process.
If i need to change the port settings in SQL, is that just the Client neetwork utility I should change or should i run the setup.
Any input appreciated.....
:-)
-MAK
Connecting To SQL DB Through A Firewall
Dec 1, 2004Hi there!
I'm a bit new to all this, so please bear with me! :)
I've got a webserver in our DMZ and I'm trying to create an ODBC connection from that server to a db server within our firewall. When I try and connect, the following message appears:
Connection failed:
SQLState: '01000'
SQL Server Error: 10060
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()),
Connection failed:
SQL State: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied
I'm at a bit of a loss as to what's going on, as we have an application on the webserver that connects to another SQL DB server within our firewall with no problem!
webserver:
OS - win2000 standard server sp4
db server:
OS - WinNT 4.0
SQL - 7.0
If anyone can help, it would be much appreciated!!
Cheers,
Ewan :)
Can't Use SQL Server With Firewall
Jul 20, 2005My ISP recently had me reset my TCP/IP stack. After that, Norton PersonalFirewall prompted me twice that SQL Server was trying to access theInternet. Both times I responded to allow it to and to always use thataction. Now I am not able to use SQL Server with NPF enabled. If I disableNPF, SQL Server works fine.I am using the desktop edition of SQL Server 7, on a standalone PC, notconnected to a server. I have been using SQL Server and NPF together forover a year. Now, since my TCP/IP stack was reset, NPF interferes with SQLServer.Anyone have any experience with this?Thanks,Neil
View 3 Replies View Related