DB Engine :: Convert Host Name To IP Address
Jun 10, 2015Is there any way/script/command to convert hostname to IP address in SQL Server.
View 7 Replies
ADVERTISEMENT
DB Engine :: Host-name And Name Are Not Same?
Aug 31, 2015when I run the Query "Select @@ServerName" it is providing the server name which is not same as I connect to SQL Server.example : My SQL Server Name is "XXX123" and when I run the above query it is Printing as "YYY123"
View 5 Replies View RelatedCan I Host A SQL2005 EE DB On SQL2000 Engine ?
Jan 2, 2007Hi,
I'd like to host a small website created using VS2005 EE with a company that offers just SQL2000 DB support.
My question, can i use the DB created by VS site manager as a DB to the site, if not, is there any alternatives.
Thanks.
DB Engine :: How To Convert Unique Clustered Index Into Clustered Primary Key To Use With Change Tracking
Sep 4, 2015We are going to use SQL Sever change tracking. The problem is that some of our tables, which are to be tracked, have no primary keys. There are only unique clustered indexes. The question is what is the best way to turn on change tracking for these tables in our circumstances.
View 4 Replies View RelatedWhat Is The Host Name?
May 30, 2007I am trying to connect to a remote MSSQL database through a manager program called "SQL Manager Lite". The first thing that the wizard asks me is the "host name".
How do I find this host name? I just mention that I am trying to connect to a database on a shared hosting.
.
Building An NT Box To Host SQL 7
Oct 25, 1999I'm in the midst of planning how to build an NT box to host SQL 7.0 and was wondering if there is any advantage to segregating the RAID 5 Array (5 x 18GB drives) into numerous *logical* partitions to separate database and log files (I can't see what advantage there would be if the disks are all on the same array, but..)
If anyone has any pointers or links to recommended NT configurations for hosting SQL, I'd appreciate hearing them.
TIA,
RM
Host Name Not Displayed
Jul 19, 1999When using sp_who and sp_who2 on SQL Server 6.5 I seem to get inaccurate results .
Each spid seems to be using the same host name, and the host name used is one that hasn't been connected to SQL server for several months.
Is there a problem with the connection management ? If so how do I find this out ? and how do I fix it ?
Change Host Name
Oct 19, 2007hi,
I change the PC name. so now @@servername returns the oldname.
I try sp_dropserver and I got an error:
Msg 15015, Level 16, State 1, Procedure sp_dropserver, Line 42
The server '[IBM-E81EB247FF3]' does not exist. Use sp_helpserver to show available servers.
I run sp_helpserver and I get the oldname:
IBM-E81EB247FF3IBM-E81EB247FF3 rpc,rpc out,use remote collation0 NULL00
any idea ?
many thanks
Noam
Noam Graizer
Deploy .MDF To A Web Host
Mar 17, 2006Hi all,I'm new to SQLServer (Express edition) so I was wondering: if the webhost supports SQLServer 2005 do I just need to move the .MDF file to mydirectory on the web host to be able to use it?Thanks,Lorenzo
View 3 Replies View RelatedThe Worst Asp.net Host
Jul 20, 2005Whatever you do, don't try aspwebhosting.com . One day recently I gotan email from them saying that my account had been suspended for usingtoo much cpu time. There was no further explanation. Those bastardstook my site offline, removed my email account, blocked my ftp accessand even refused to let me get a backup of sql-server data. I sentthem an email (using a yahoo account since they had shut down my ownserver) to ask what I could do to get my data. Rather than answer myemail they simply put me their BLOCK list. All of my emails are nowautomatically bounced. I only sent them one email and it was verypolite. My website is gone. My data is gone. All of my files aregone. The loss of time and effort combined with damage to my businessis unforgivable
View 6 Replies View RelatedIs There A Free Ms Sql Host?
Oct 5, 2006I am looking for a free ms sql database for my programs, but i don't want to host it on my computer, because my web host does not allow servers to be run and people connecting to thme.
View 1 Replies View RelatedHow To FTP To Host(Mainframe)?
Jan 24, 2008Hi,
I am trying to send files over to an ftp server on Mainframe using scripts that is provided in this link, but I can't get it to work.
The problem is the sendfile method concatinates the source file name to the MVS dataset name which causes the issue.
Here's my code (FTPConn is a connecation mgr for FTP):
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Public Class ScriptMain
Public Sub Main()
Dim mgr As ConnectionManager
mgr = Dts.Connections("FTPConn")
Dim conn As FtpClientConnection
conn = New FtpClientConnection(mgr.AcquireConnection(DBNull.Value))
Dim toFiles As String
toFiles = "ftpp.a.b.xxxxx.yyyyyy.int"
Dim fromFiles(0) As String
fromFiles(0) = "c: est.txt"
Try
conn.Connect()
conn.SendFiles(fromFiles, toFiles, True, True)
Catch ex As Exception
Finally
conn.Close()
End Try
Dts.TaskResult = Dts.Results.Success
End Sub
End Class
Output:
SSIS package "Package.dtsx" starting.
Error: 0xC001602A at Package, Connection manager "FTPConn": An error occurred in the requested FTP operation. Detailed error description: 200 Representation type is Ascii NonPrint
200 Port request OK.
501 Invalid data set name "ftpp.a.b.xxxxx.yyyyyy.int/test.txt". Use MVS Dsname conventions.
SIMPLE Command To Convert String To Number? Not CAST Or CONVERT.
Aug 15, 2006Dear Experts,Ok, I hate to ask such a seemingly dumb question, but I'vealready spent far too much time on this. More that Iwould care to admit.In Sql server, how do I simply change a character into a number??????In Oracle, it is:select to_number(20.55)from dualTO_NUMBER(20.55)----------------20.55And we are on with our lives.In sql server, using the Northwinds database:SELECTr.regionid,STR(r.regionid,7,2) as a_string,CONVERT(numeric, STR(r.regionid,7,2)) as a_number,cast ( STR(r.regionid) as int ) as cast_to_numberFROM REGION R1 1.00112 2.00223 3.00334 4.0044SELECTr.regionid,STR(r.regionid,7,2) as a_string,CONVERT(numeric, STR(r.regionid,7,2) ) as a_number,cast (STR(r.regionid,7,2) as numeric ) as cast_to_numberFROM REGION R1 1.00112 2.00223 3.00334 4.0044Str converts from number to string in one motion.Isn't there a simple function in Sql Server to convertfrom string to number?What is the secret?Thanks
View 4 Replies View RelatedWeb Host MS Sql Performance - My Fault?
Feb 14, 2007Hi,
I'm using SqlServer 2000 at a web host, and share this db with about 200 others (it's an inexpensive web host so I guess there is not very much traffic on most of them, but I can only see their db IDs so I don't know what organisations they are or the urls they have).
Usually, my web site runs fine, but lately it's really really slow (as in non-functioning in reality). I'm in the middle of coding my seach functionality, so I fear that I'm causing this myself. ;-)
However, there are only ten posts in my test db, so it should be a piece of cake for SqlServer. The other .aspx pages runs rather slow too now, but when I start a programming session they have worked fine (this has happened three times now so I don't know what to conclude). When the server slows down, it can stay down for hours. I've also tried to access my site from other computers but get the same result, so I guess it has nothing to do with caching (I also tried emptying my browser's - IE7 - cache). I have several asp web sites with Access dbs at the same web host, and they all work fine. In addition, I have no problem viewing and editing my db at the web host via SqlServer Management Studio Express.
What do you think of this problem? Should I go for a more expensive web host? Should I give them the "It's not you, it's me" speech? ;-) Or is it really me?
Below's my search code, and as you can see, there are some integers there to make sure the loops don't run ad infinitum. I don't really think the problem actually lies with my search code, as everything worked well a week ago, but I don't know...
BTW, if you think my code can run much faster without getting too tricky, please let me know.
Please help!
Pettrer
If Page.IsPostBack Then
Dim soktext As String = Trim(SokTextBox.Text) + " "
Dim tillagg As String = ""
Dim varv As Integer = 1
Dim loopvarv As Integer = 0
soktext = Replace(soktext, vbCrLf, " ") 'vbCrLf = mellanslag i VB-terminologi
Do While InStr(soktext, " ") And varv < 100
soktext = Replace(soktext, " ", " ")
loopvarv += 1
Loop
While Trim(soktext).Length > 0 And varv <= 20 'Loop för att identifiera ord och lägga till dem i sqlsatsen, ett i taget
Dim icke As String = " "
Dim ordet As String = soktext.Substring(0, soktext.IndexOf(" ")) 'Det godkända ordet läggs till i tmp-strängen
soktext = soktext.Remove(0, soktext.IndexOf(" ") + 1) 'Tar bort det som just använts (eller varit för kort)
If ordet.Length > 1 Then 'Blanksteg och ensamma bokstäver förhindras att komma med i sql-satsen
If ordet.StartsWith("-") Then 'Det är ett minusord
icke = " NOT " 'I sqlsatsen blir det alltså AND NOT (...)
ordet = ordet.Remove(0, 1) 'Tar bort minusttecknet från söksträngen
End If
tillagg += " AND " & icke & " (artistnamn LIKE '%" & ordet & "%' OR " & _
"beskrivning LIKE '%" & ordet & "%' OR " & _
"kulturhemvist LIKE '%" & ordet & "%' OR " & _
"kontaktnamn LIKE '%" & ordet & "%') "
End If
varv += 1
End While
Dim kat As String = ""
If KategoriDropDownList.SelectedValue <> 0 Then
kat = " AND (kategori1 = " & KategoriDropDownList.SelectedValue & _
" OR kategori2 = " & KategoriDropDownList.SelectedValue & _
" OR kategori3 = " & KategoriDropDownList.SelectedValue & _
" OR kategori4 = " & KategoriDropDownList.SelectedValue & ") "
End If
Dim lan As String = ""
If LanDropDownList.SelectedValue <> "alla" Then
lan = " AND lan = '" & LanDropDownList.SelectedValue & "' "
End If
ResultatDataSource.SelectCommand = "SELECT DISTINCT TOP 200 folknuID, kategori1, kategori2, kategori3, kategori4, initial, artistnamn, lan, kontakthemsida, kategori1, (COALESCE(audio1,'') + COALESCE(audio2,'') + COALESCE(audio3,'')) As audio, (COALESCE(video1,'') + COALESCE(video2,'') + COALESCE(video3,'')) As video, (COALESCE(pressbild1,'') + COALESCE(pressbild2,'') + COALESCE(pressbild3,'')) As pressbild " & _
"FROM Mytable " & _
"WHERE shown = 1 AND shownadm = 1 " & _
tillagg & _
kat & _
lan & _
"ORDER BY initial"
ResultatLabel.Text = "SelectCmd: " & ResultatDataSource.SelectCommand
ResultatGridView.DataBind()
End If '*** på sökkoden
SQL Express On A Public Web Host
Mar 28, 2007Are there any restrictions, limitations or anything to prevent the use of SQL Express database being used with my ASP.NET 2.0 application on a public web host?
If so, what are they?
Thanks.
Move Mdf Database To Host
Jan 20, 2008HiAs i have read, there have been discussions before how to move a local MDF databas to MSsql server at a webhost.But i cant figure it out, i know the answere is out there but i cant find it.I have downloaded the Host Deployment tool that generates a .sql file from my database, it looks ok.The problem is that my host dont allow me to execute this. I have also tried to run a file called RunSql.aspx that should help me execute my .sql file.But i recieve errors
Opening url http://mydomainz1.com/mydbfile.mdf.sqlAn error occured: System.Net.WebException: The remote server returned an error: (404) Not Found. at System.Net.HttpWebRequest.GetResponse() at ASP.runsql_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in d:hsadminaccoundidmydomainz1.comRunSQL.aspx:line 58The line 58 is empty
Is there anyway that a mdf file that i have build in VWD 2005 can work as a standalone database?I would like it to be as a .mdb database that is simple to move and so on.
Or do the mdf database have to have a MSsql Express or a MSsql Server?
Grateful for help!
/ mitmit
What Is The Best Way To Export MSDE Db To SQL Db On Host?
Jul 22, 2004I have a DNN install on my local PC that I would now like to transfer to my remote host server. What is the best way to do this? I have exported the db locally but see no way to import it on the host.
Thanks!
SQLEXPRESS Database To Host
Feb 10, 2006I created a sqlexpress database in visual studio 2005 and can't figure out to move the database to my hosting company( godaddy ). I can't connect remotely to the database on my hosting company. Whats the best way to go about this?
View 1 Replies View RelatedChanging Host Server Name
Oct 24, 2000At work, we are in the process of moving a server running SQL Server 7 from one domain to another. A part of this domain change will necessitate that the server be renamed. In a couple of tests that we ran we found that changing the domain does not cause problems, but changing the server name does. How does one register the databases with the new server name without reinstalling everything from scratch?
Any assistance would be greatly appreciated as we are under a time crunch here. Please reply to my email as I am unable to check this board often.
Thanks,
Mike Sinnott
SQL 6.5 And SQL 7.0 Simultaneously Active On Same Host
Mar 26, 1999Has anyone developed a workaround to have SQL 6.5 and SQL 7.0 simultaneously active on the same NT 4.0 Server host. The use of VSWITCH.EXE to switch between SQL 6.5 and SQL 7.0 in not an acceptable solution. There are several applications that are only supported under SQL 6.5 and will not be upgraded to SQL 7.0 for another 3 to 6 months.
There are other applications (ERP and data mart) that were developed specifically for SQL 7.0 to take advantage of its new DTS, OLAP, and query capabilities.
All these applications need full-time access to their respective databases.
The obvious solution is to host SQL 6.5 and SQL 7.0 on separate servers. The client has a "monster" database server which would be too expensive to duplicate. Using a "standard" PC to host SQL 6.5 would significantly compromise performance of those applications.
Any advice or suggestions would be appreciated.
Andrew Dominguez, IMS
ajd@cwix.com
909.625.4066 / 7826 fax
Rename SQL Server Host Name
May 31, 2001I have change the name of my host by "network neighborhood"
and user sp_dropserver and sp_addserver.
But when rebooting the host, I have this following message.
"Your SQL Server installation is either corrupt or has been
tampered with (unknown package id). Please run setup."
But I change the name of the hostanme to the former name, there
is no error.
Please, can you advise me something ?
MS SQL Problems After Host Migration
Nov 17, 2004My reseller web host (DIY) migrated a few weeks ago to a new data center.
Unfortunately, my MS SQL databases were not migrating properly. (as well as
other things). I have multiple sites that are not functional due to
problems with their migration.
When I looked at some of the databases, the table structure had been
migrated, but not the data and apparently something else.
Some of the databases of this error when trying to access it:
--- error ---
Error for database: DATABASENAME
Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name 'TABLENAME'.
--- end error---
Some of the databases I can actually access but get:
Microsoft OLE DB Provider for SQL Server error '80040e2f'
Cannot insert the value NULL into column 'TABLENAME', table
'DATABASENAME.dbo.TABLENAME'; column does not allow nulls. INSERT fails.
Everything in all databases worked perfectly before the migration.
They tell me that they have done what they can. They tell me that they are
at the mercy of Psoft who assisted with the migration.
Does anyone know of anything that can my host that can help them figure out
the problem.
Any assistance will be GREATLY appreciated.
Migration From Physical Host To VM?
Jun 25, 2015 we have:
(1) one physical server :
OS : Windows Server 2003
Active Directory, DNS, DHCP, File Server, Print Server and SQL Server 2005
and we will install new (2) two server for High Availability with VMware vSphere (ESXi) 6.0
and we will have (2) two Virtual Machine :
1st VM :
OS : Windows Server 2012 R2
Active Directory, DNS, DHCP
2nd VM :
OS : Windows Server 2008 R2 (becaure SQL Server 2005 does not work with 2012 R2 link)
SQL Server 2005 Service Pack 3
My Question is : What is a safe method to Migrate Database's from Physical Host (Windows Server 2003) to 2nd VM ?
Error 11001:No Such Host Is Known.
Nov 11, 2006I was trying to allow remote user to access sql server 2005 database.I have done configuration and tested on my computer,it works well.But from other computer,I can not use the new user to login.
Error message is :no such host is known.
How can I resolve it?
Copying A Database From Web Host
May 21, 2007Hi. I have a client with a database hosted on SQL Server 2005. I don't have a paid version of SQL Server at home so am just using SQL Server Express. I'm getting INCREDIBLY FRUSTRATED that I can't use the "copy database" wizard from SQL Server Express.
Am I just out of luck on this? I can't use the "copy database" feature since I'm using Express. I can't get the actual files since the database is on a shared server. I know I'm not the only person with this issue; I see people asking the question but I don't see any answers.
Is there any way I can copy this database?
Thank you very very much,
- Andrew Clarke.
User Can Only Login From A Specified Host
Jul 18, 2007Hi
I'm trying to create a login (Sql Server 2005) that can only connect from a specified host. Im sure this is
possible but i cant seem to find the option anywhere.
eg. a login that can only connect from localhost or maybe an address range like 192.168.0.%.
Thanks
Do Any ISP's Really Host SQL 2005 Express
Jul 30, 2006Hi, I've been a SQL Server dba for about 10 years, so i know SQL quite well. I've recently started using VWD express, and as it says, its quick and easy to create a website, which I've done. It all works great on my local machine. I've just signed up with an isp and duly ftp'd the project files plus the mdf and ldf that lives in App_Data into their content area, and rather naively I expected it all to work. The pages come up fine until some database access is called for, then i get the seemingly infamous error:
... (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) ...
I've researched this for 2 solid days now, examined forums and posts, followed advice and enabled protocols and so on. Support at the isp in question does not really have a clue about databases and connections strings. Then I started looking closely at the words used by the isp's, none of the isp's explicitly say they support sql 2005 express. They do say SQL 2005, but not express. They do say VWD Express, but not SQL 2005 Express. So does anyone know what is/is not possible with regard to deployment of SQL 2005 express. Does anyone have experience of running SQL express on a production server, or a shared hosters machine? Its been out now for nearly a year I think, so hopefully someone has the answer.
Thanks if you can help! Charlie
Connecting To SQL Server On A VPC Host
Jan 19, 2008VPC Host: Vista 64Bit
VPC Guest: Win2K3 (32Bit)
VPC is configured to use the wireless card on the host.
Firewalls on both systems are completely disabled.
Machines can ping each other.
Both machines can access the Internet.
I can browse the SQL Reporting Services Web Site on the Host from the Guest.
Host SQL Install has remote connections enabled.
If I browse for Network server from teh connect dialog on teh Guest, it finds the Host.
Why can't I connect to the Databse Engine on the Host from the Guest?
I have tried both TCP/IP and Named Pipes and both show a connection failure. (Not a login failure)
If it matters, the Guest OS also has a SQL Database Engine running. But I don't know why that would stop me from connecting to a remote instance.
And suggestions would be appreciated.
Thanks.
J
Works Locally But Not On Host
May 1, 2008
I am very confused. I've finally gotten everything to work the way I want on my pc, but when I ftp to the Internet (URL is hosted on GoDaddy), everything goes haywire. I had to create a new database on the host server, and when I use an aspx login, I get the following message:
The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.
I know what the connection string to the database is, but where do I enter that information? I'm obviously new at asp.net and sql, and I need major help.
Thanks. Linda
&&<Host System.Messaging In CLR&&>
Dec 2, 2006Hi All, i am trying to host the system.messaging.dll in SQL Server. I get the usual warnings about not being fully trusted. I am prepared for MS not supporting. But, when i execute my trigger (which writes to message queue), the trigger fails with an exception of 'That assembly does not allow partially trusted callers'. So. is there no way for me to write to MSMQ using triggers? Do i have to rethink my strategy?
imports System.Messaging
Dim msmq As MessageQueue = MessageQueue.Create(".TestQueue", False)
msmq.Send("Test")
Thanks for the help
Aspnetdb On Host, Connection String
Aug 28, 2006HiI am having trouble connecting to aspnetdb on the shared host. On my local server this is my connection string which works fine: <add name="MyLocalSqlServer" connectionString="Data Source=.SQLExpress;Integrated Security=SSPI;Initial Catalog=aspnetdb;User Instance=false"providerName="System.Data.SqlClient" />But, this doesn't work on the host (just putting in host address):<add name="MyLocalSqlServer" connectionString="190.40....232,1444;Integrated Security=SSPI;Initial Catalog=aspnetdb_booksale;User Instance=false"providerName="System.Data.SqlClient" />,and I get the error :Login failed for user ''. The user is not associated with a trusted SQL Server connection.so I put in the user id and password that i used when I created the aspnetdb_booksale db<add name="MyLocalSqlServer" connectionString="Data Source=196....232,1444;Integrated Security=False;User ID=aspnetdbbooksale; password=amanda;Initial Catalog=aspnetdb_booksale;User Instance=false"providerName="System.Data.SqlClient" />and I get the error:The ConnectionString property has not been initialized. Any ideas for me?Amanda
View 3 Replies View RelatedAble To Connect Via Local Host But Not Server
Sep 14, 2006I have a page that connects to SQL server. It works fine when running in local host but when I publish to the server, I get the following: 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)
Any ideas on where to start? Thanks,Mark
Copying SqlServer Database From Web Host
Mar 14, 2007Hi,
I have a hard time copying my db (or instance?) from a SQL Server 2000 db which resides at my web host. I have Sql Server 2005 Express and Sql Server Management Studio Express on my computer and, well, there is no "ftp-like" option so I don't have a clue about how to proceed. I've read many posts on the net on this matter but nothing seems to apply to this, in my mind, rather common, configuration.
I have receieved Excel docs that should be appended to tables in my db. I have successfully installed DTS (see http://mobiledeveloper.wordpress.com/ for details - it's really simple but takes two hours) so I have a wizard for the actual import from Excel. My plan is now to
1. download/detach/whatever my table/db/part of the web host's db and download it to my computer. Then
2. fill the tables with the data from Excel. And finally, to
3. upload/attach/whatever my local db or table to the web host again.
I'm sooo confused, please, please help me out here!
Pettrer